How do you ask for input from the user to filter out just those r.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do you put in a query or on a switchboard requesting input from the user.
This input filters out just those records and puts them into a report. The
example is I want items from a certian date. I want only items with the
specific dates specified with input from the user to be shown on a report.
If anyone can help me it would be appreciated. Thanks a ton.

Yackoooligan
 
In the query (upon which your report is based) you need to specify the
desired dates.

For example, if you have a "date created" field on your report and you want
to see all records after a given date, you'd add the "date created" field to
the query. In the criteria field youd put something like...
[EnterStartDate]


This would prompt the user to enter a date and the querry would find records
where the date was greater than that entered by your user.

Post back with specifics if you need more help. Include things like the
names of your fields, and what criteria you wish to use.

rick b



How do you put in a query or on a switchboard requesting input from the
user.
This input filters out just those records and puts them into a report. The
example is I want items from a certian date. I want only items with the
specific dates specified with input from the user to be shown on a report.
If anyone can help me it would be appreciated. Thanks a ton.

Yackoooligan
 
Back
Top