Help with reports setup

  • Thread starter Thread starter Os
  • Start date Start date
O

Os

I'm using Access97, and I need some help setting up some
reports. I have a main form that contains many objects
(lbls, txts, comboboxes, cmds, etc.) After the user
select/enter data into the form, the data is then saved
to my main table. Most controls on the form are bound to
their matching field in the main table. I used Excel
pivot table to generate reports from Access, but I'd
rather use Access queries/reports. My problem when I try
to run a report from a query, it will show all the data
in the table for that query. If need to print out
productivity by employee for a given day, the report will
show the productivity for eveything on table (entire
year!). Another thing, how do I go about make the report
to show specific data on separate page? Remember my users
they don't know anything about Access. They just want to
click and print!
Any help is highly appreciated.
Thanks.
 
In short, when the user runs a report, you need to have a form pop up with
several fields on it for them to make selections. There should be a field
for them to enter (or select from a list) the employee on which to report.
If left blank, it would print all. There should also be fields for the date
range.

In your query for the employee, include criteria such as...

Like [Forms]![ReportParameters]![EnterUserID] & "*"

The &"*" allows them to enter a partial id or leave it blank and get all.

For your dates enter something like...

Between [Forms]![ReportParameters]![EnterStartDate] and
[Forms]![ReportParameters]![EnterEndDate]


Have a 'OK' button on your form. When clicked, HIDE the form, don't close
it. Alos, remove the close button. If the form is closed, the report and
query won't be able to use the data.

In your report ONCLOSE property, reset each of your fields so they will be
blank for the next user...

[Forms]![ReportParameters]![EnterUserID] = ""
[Forms]![ReportParameters]![EnterStartDate] = ""
[Forms]![ReportParameters]![EnterEndDate] = ""

Then close the form.



Hope that helps,

Rick


I'm using Access97, and I need some help setting up some
reports. I have a main form that contains many objects
(lbls, txts, comboboxes, cmds, etc.) After the user
select/enter data into the form, the data is then saved
to my main table. Most controls on the form are bound to
their matching field in the main table. I used Excel
pivot table to generate reports from Access, but I'd
rather use Access queries/reports. My problem when I try
to run a report from a query, it will show all the data
in the table for that query. If need to print out
productivity by employee for a given day, the report will
show the productivity for eveything on table (entire
year!). Another thing, how do I go about make the report
to show specific data on separate page? Remember my users
they don't know anything about Access. They just want to
click and print!
Any help is highly appreciated.
Thanks.
 
Back
Top