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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

#error - Blank 3
Query with empty fields 1
Blank Fields in NOT Null Query Criteria 5
Query Problem 2
Make table query: [Enter 1] AS Test 1
Erratic results from query criteria 3
Data Not Displayed in Query 2
Criteria in a Querie 8

Back
Top