Date calculation

[racdata]

Hi all

I have a report and before opening the report Access prompt me for the Start Date then the End Date. This is displayed in the header.

If I enter the dates from 01-11-2003 to 15-11-2003 can I calculate the days. It should display then 15 days

Is this possible and how do I do this. There is only one date field in the querry. Named [EVENT_DATE]

 

[Rich]

Add two unbound hidden textboxes, set their control source to =Min([MyDateField]) and = Max([MyDateField]) assuming their called text1 and Text2 just add another box, =[Text1]-[Text2]