Using Date parameters

[ct51598]

I have several tables with date fields in my database. I am trying to get a
summary report which gives totals (count and sum) into one report. How do I
do this where I can have the user only enter the beginning and end date one
time?

 

[Marshall Barton]

I have several tables with date fields in my database. I am trying to get a
summary report which gives totals (count and sum) into one report. How do I
do this where I can have the user only enter the beginning and end date one
time?

Create a simple unbound form with two text boxes for the
dates and a command button to open the report. Then the
simplest (not the best) way to get what you want is to
change the query's parameter prompt strings to form text box
references.