I'm working on a form that generates a query that the user can export
(I'm not working with reports - just with queries). The form allows
the user to filter the data using several fields. One of the fields is
ethnicity. So you can generate data of just white employees, of just
asian, etc. One of the users has asked me if I can set up a new option
of selection just minorities (which would be maybe 6 out of the 7
fields). I've played around a bit with this, but I'm having difficulty
figuring out how to manipulate the form/query so that all but white
employees display (while still retaining the option of displaying just
one ethnicity).
Any suggestions. I'm not super technical, so if it involves lots of
programming, it might be over my head. Can follow some straightforward
code (case statements, if statements etc.)