Forum home » Delegate support and help forum » Microsoft Access Training and help » OR Query
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
OR Query
Resolved · Low Priority · Version 2003
Reply Thu 17 Jul 2008, 16:50Delegate Chris said...
Chris has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Access VBA course
Excel VBA Advanced course
Project Intro Intermediate course
OR Query
How do you construct a multiple 'OR' Query? Do you include on the same line as the first 'OR' criteria or do you have to use the next line down?
For upcoming training course dates see: Pricing & availability
RE: OR Query
Dear Chris
Thank you for attending Access courses. I hope you enjoyed the courses and are finding the topics covered during the training useful.
In Query Design View if you enter the criteria on the same line for multiple fields it becomes an AND query indicating that all the Criteria MUST be met before for the records to be displayed.
If you want OR query then you have to enter the criteria on the next line. This means that no two criteria should be on the same line unless you specifically want the records to meet those criteria!!
I hope this answers your query! If this has answered your question then may I please request you to mark this post as resolved!!
Many thanks
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000/2003
MCAS Master Instructor 2007
|