Help with Criteria Field

[Kira]

Okay so I have a report that I want to show data from 2 specific dates when it is opened. In the query that it is linked to one field has the expression:

Actual Quantity: IIf([Transaction Types].[Add/Remove]="Addition",[Inventory Transactions].[Quantity],-1*([Inventory Transactions].[Quantity]))

-that shows the different transactions and the dates that they were done.

Under they criteria for that field I put BETWEEN [Enter Start Date] AND [Enter End Date], and when I go to the report a pop up comes up asking for the start and end dates, which is what I want. Unfortunately no matter how I type the dates in it either displays no data or says the data was typed incorrectly or is too complex. How do I change want the input pop up wants so that the date could be put in like July 7, 2008 or 07/07/2008?

 

[redneckgeek]

That field is not returning a date, so that's the wrong place to put your criteria. Put your criteria under the date field you want to compare to.