Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query with 12 fields from 4 differant tables, I'm need to get the
user to search any of the fields, leaving some blank but still getting
results from the blank fields. I can't seem to get the quey to run without
asking for input from the fields that are blank. Any help would be welcome.
Brian
 
Try this:


Select * from myquery where F1 = myform.F1 or F2 = myform.F2 or F3 =
myform.F3


Linda
 
Back
Top