Date Parameters

  • Thread starter Thread starter Chuck
  • Start date Start date
C

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.
 
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
Click to expand...

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
 
Back
Top