 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / June 2005how to enter OR function in access
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. > 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 [quoted text clipped - 4 lines] > Thank you for your help, > Carla 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 > 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 [quoted text clipped - 14 lines] > > Thank you for your help, > > 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. ;-) > 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 [quoted text clipped - 20 lines] > > > Thank you for your help, > > > Carla |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.