Thread: Question Multi criteria query
View Single Post
Old 07-12-2019, 12:11 PM   #3
Micron
AWF VIP
 
Join Date: Oct 2018
Location: Ontario, Canada
Posts: 1,235
Thanks: 10
Thanked 232 Times in 220 Posts
Micron has a spectacular aura about Micron has a spectacular aura about
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 offline   Reply With Quote
The Following User Says Thank You to Micron For This Useful Post:
goophibama (07-12-2019)