Need help with report

  • Thread starter Thread starter Jim Wazorick
  • Start date Start date
J

Jim Wazorick

Hi guys. I was wondering if you could help me with some problems I'm
having with Access and reporting. I'm working on a side job creating a
report that brings in data from many different tables. I don't have a
lot of experience with using reports in Access but tried to do it
anyway. However, now whenever I run the report, it keeps asking for
parameter values for most of the text boxes that I've linked to the
various tables. Each table should be linked to the others by a unique
ID. Also, I'd like the report to display data for only one individual
instead of everyone in the database. Ideally, a box would pop up
asking the user to input an ID that would display only that person's
data. I use Access 2000 if that helps. If you need any more
information from me, please let me know. Thanks in advance.

Jim
 
Hi Jim

it's normally easier to base a report on a query than anything else (IMHO)
... therefore i suggest you create a select query which has all the tables
needed shown up the top (ensure that they're all linked) and then select the
fields that you want to show in the report (double click on them to move
them down to the bottom half of the query grid).
In criteria line of the ID field type
[Enter the ID]
now press the red exclaimation mark ... enter an ID that you know has data
and check the output. If this is what you want to see in your report then
save the query and then use the report wizard (create report using wizard)
to create a report based on this query.

Every time you run the report you will be prompted to enter an ID number.

Let us know how you go
Cheers
JulieD
 
Back
Top