Hello, I'm using access 2003 and am trying to create a search function that would allow me to do the following:
i have a table with 4 fields called "sort1" "sort2" "sort3" and "sort4"
on the form i have 4 combo boxes that pull from the same menu of sort options (in a seperate table); for some clients I fill in one field, for others, two and so on...
I need to be able to write a query that would pull up any record that, for ex, said "lawyer" in ANY of the 4 fields -- how can I do that???
I'd also like to be able to narrow by more than one attribute, for ex - to bring up records that are "lawyer" AND "personal" - again, in any of the 4... (i also have another combo box listing "male" or "female" and I'd like to also qualify the search by gender or "show all" etc...)
i did the gender one already by setting up a query that reads iif(forms!mySearchForm!combo2="show all",[gender],forms!mySearchForm!combo2) -- this works fine for gender - but i'm stuck on the others cuz of the complexity of needing it to pull from ANY of the fields... i hope i'm expressing this clearly enough :) let me know what else you need to know
thanks so much!