Thread: Question Multi criteria query
View Single Post
Old 07-12-2019, 12:11 PM   #3
Micron
Newly Registered User
 
Join Date: Oct 2018
Location: Ontario, Canada
Posts: 794
Thanks: 10
Thanked 161 Times in 155 Posts
Micron will become famous soon enough Micron will become famous soon enough
Re: Multi criteria query

get rid of the "and" for starters because that is putting the literal word 'and' as part of your date field criteria. Then there is the fact that you have each critieria on separate rows, which means "gimme based on this" OR "gimme based on that". If on the same row, it is an AND situation. Your post reads like you want "and", so on one row. You could try either way.

__________________
Sometimes I just roll my eyes out loud...
Windows 10; Office 365 (Access 2016)

Last edited by Micron; 07-12-2019 at 12:11 PM. Reason: clarification
Micron is online now   Reply With Quote
The Following User Says Thank You to Micron For This Useful Post:
goophibama (07-12-2019)