access forms & reports

[csegal]

I have a simple form that was created to track equipment calibration.
The Form Name is: Calibration Record
The Query Name is: Tools Query
The Table Name is: Tools
The Report Name is: Calibration Due
The report called Calibration Due is based on a query called Tools Query, The query gets information from the form Calibration Record form.
On the Calibration Record form I have a command button to open a mini form called Tools Query which has a start date text field and an end date text field.
I am trying to get the mini for to only return the specified date range from start & end dates.
Can someone please help, this is driving me maddd!
I can be reached at:

csegal@fineair.com

Thanks

 

[kerrigirrl]

are you typing in the date range somewhere? if you are on the form, in the query you can say in the criteria:

between [Forms]![frmxxx]![LowDate] AND [Forms]![frmxxx]![HighDate]

i'm not sure if this is what you're looking for.

kerri