how to enter OR function in access

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

Guest

I have linked two tables, one of which has blank fields and therefore doesn't
return any line item with a blank. How can I say =or("",>0) in my query
criteria so that no matter what is in it? OR is there a way to say return
anything that is null or not null in case there may ever be a letter value
present?

Thank you for your help,
Carla
 
Assuming I'm reading you properly, open the query in Design mode,
double-click on the line joining the two tables in the top of the Query
window, and choose either Option 2 or 3, depending on whether you want all
of the entries from Table A and any matching ones from Table B, or all
entries from Table B and any matching ones from Table A.

Look in the Help file for the entry "About joining tables or queries in a
query, and look for "Types of Joins". Look up "Inner" and "Outer" joins.
 
If I could kiss you I would. I can do pretty well in Access, but that is
something I never knew about and will always remember! Thank you thank you
thank you!!!

Carla
 
Glad to be of service! Nice to be able to help someone else on here for a
change; usually I'm the one asking the questions. ;-)
 
Back
Top