I have a query that has one column that groups names together, a second column that sums up the quantity of how many total units someone has received, and then a third column that has purchase dates in it that is set to "where". I am trying to set a criteria in the date column to show results between two dates that will be set on a form. For whatever reason when I put my conditions in the query it returns a blank query.
I'm using this as my criteria:
>=[Forms]![Form1]![Date1] AND <=[Forms]![Form1]![Date2]
I know this should be simple and I have gotten this same concept to work in another database. I just can't understand why I keep getting a blank query as my result.
I'm using this as my criteria:
>=[Forms]![Form1]![Date1] AND <=[Forms]![Form1]![Date2]
I know this should be simple and I have gotten this same concept to work in another database. I just can't understand why I keep getting a blank query as my result.