start and end dates in a query

[rap43]

I have a query that I like to run a report by dates, start date and end date.
I have a report now that I can run but I have 2 years of dates in the table
in 200 records and I only need so many in the report. I can set the criteria
in the query with the between command and then run the report. I like to be
able to select dates that would temporary set the query and run the report.

rap43
Please respond only to this newsgroup.
I do not reply to personal e-mail

 

[fredg]

I have a query that I like to run a report by dates, start date and end date.
I have a report now that I can run but I have 2 years of dates in the table
in 200 records and I only need so many in the report. I can set the criteria
in the query with the between command and then run the report. I like to be
able to select dates that would temporary set the query and run the report.

rap43
Please respond only to this newsgroup.
I do not reply to personal e-mail

As criteria on the query Date field, write:

Between [Start Date] and [End Date]


You will be prompted to enter the 2 dates.

 

[rap43]

Thanks loads

I have a query that I like to run a report by dates, start date and end date.
I have a report now that I can run but I have 2 years of dates in the table
in 200 records and I only need so many in the report. I can set the criteria
in the query with the between command and then run the report. I like to be
able to select dates that would temporary set the query and run the report.

rap43
Please respond only to this newsgroup.
I do not reply to personal e-mail

As criteria on the query Date field, write:

Between [Start Date] and [End Date]


You will be prompted to enter the 2 dates.