Reports on the fly

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

Guest

I just converted a Lotus Apporach file to Access. In Apporach you are able to
more or less do a, "report on the fly". Change the criteria for a report. Is
this an available feature of Access, and if it is, could you guide me to
instructions on setting it up in this database. So what I am looking for is
not to have 20 or 30 reports, I would like to change the report to issue dat
afrom one or many fields. Thank you in advance.
 
It is quite nice. I am on a mission to rid all Access of parameter prompt
queries. Martin's site has lots of great methods.
 
I just converted a Lotus Apporach file
to Access. In Apporach you are able to
more or less do a, "report on the fly".
Change the criteria for a report. Is
this an available feature of Access,
and if it is, could you guide me to
instructions on setting it up in this
database.
Click to expand...

If I understood this correctly, you simply want to set criteria for the
records to be shown in the report... something like all records with job
title of "Mechanic", another identically formatted report of all records
with job title of "Clerk", etc., or perhaps all records with a date between
particular start and end dates.

Without using VBA (Visual Basic for Applications), a Parameter Query, as
Lynn suggested, is appropriate. Simply specify the prompt in the Criteria
line in the Query Builder, something like [Enter Job Title] or, under a date
field:

Between #[Enter start date]# And #[Enter end date]#

If you are up to learning just a little VBA, a Form with Text or Combo Boxes
to allow the user to enter or choose the values, would be even better for
the user.
So what I am looking for is not to
have 20 or 30 reports, I would like
to change the report to issue dat
afrom one or many fields.
Click to expand...

But this confuses me. Do you want to display different fields in these
reports? If so, doesn't that make them different reports?

Larry Linson
Microsoft Access MVP
 
Back
Top