Hi guys running a query where I'm only looking for two specif #'s. I know how to look for one... just enter it and that's it but what about the other??? where does that one go? I think I read somewhere that you have to add "AND" but it didn't work when I did...
"123" and "456"...
any ideas???
It depends on whether the criteria is an "And" or an "OR" Criteria. Look at this short tutorial for specifics.
http://www.datapigtechnologies.com/f...ndorinqbe.html
Alan
Alan
Click the * below to say thanks.
Database Principles
Pivot Table Tips
Good Excel Video Tutorials
Sumifs or SumProduct
DataPig Access Tutorials
MS Query Tutorial
Worst Pie Chart Ever?
Yes its access
In the design view of query add the item you want for criteria two times
- If it is an "OR" condition (Any one is true, condition is true) use criteria in
separate lines.
- If it is an "AND" condition (both conditions true, condition is true) use criteria
in one line.
Regards
Mahju
Mark the thread as solved if you are satisfied with the answer
Rule 9
Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks