Date Parameters

[Chuck]

New user here.

I created a table, form and report. When I run the report,
I would like a pop-up that asks me:

-what date range? (ex. 4/1/04 - 4/30/04)
-Customer Type
-Customer Status

Basically I want to be able to run custom reports
everytime. (ex. All Customer Type X with an Y Status in
April)

Thank you.

 

[Tom Lake]

New user here.

I created a table, form and report. When I run the report,
I would like a pop-up that asks me:

-what date range? (ex. 4/1/04 - 4/30/04)
-Customer Type
-Customer Status

Basically I want to be able to run custom reports
everytime. (ex. All Customer Type X with an Y Status in
April

Create a query using the table(s) you'd like. Then in the criteria row
under the date, put this:

Between [Enter From Date] and [Enter To Date]

and under the Customer Type field, put the criterion:

[Enter Customer Type]

Under the Status, put

[Enter Status]

Then whenever the query is opened, four questions will be asked, From Date,
To Date, Customer Type and Status. Base your report on the query rather
than the table itself.

Tom Lake