98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » OR Query
OR Query
Resolved · Low Priority · Version 2003
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?
Thu 24 Jul 2008, 14:30Trainer Rajeev said...
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
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. |
Access tip:Remove spaces in a tableIf you have a table that has too many space marks littered around, you can create a update query and use the trim function to get rid of any excess space marks |
