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.