Using a form to limit and generate a report

G

Gabe

I stumbled on directions in Access help a while ago on how to use a form to
limit information on and generate a report. For example, I want to limit
both my date and time fields (and the two fields are separate for various
reasons), to whatever I desire, then have it automatically generate the
report by the push of a button on the form. I want to do this to make my
report generating more user friendly, and so I can put in some default
values, but easily change them if necessary. I know this is possible because
someone tried to describe it to me when I was completely new to Access, but I
did not follow, then I stumbled on it when I was going through Access help
looking for something else, but I can't find it in help anymore. Anyone have
specific instructions on how to do this? Or the correct words to use in
Access help to get a hit that will describe how to do it?
 
A

Armen Stein

I stumbled on directions in Access help a while ago on how to use a form to
limit information on and generate a report. For example, I want to limit
both my date and time fields (and the two fields are separate for various
reasons), to whatever I desire, then have it automatically generate the
report by the push of a button on the form. I want to do this to make my
report generating more user friendly, and so I can put in some default
values, but easily change them if necessary. I know this is possible because
someone tried to describe it to me when I was completely new to Access, but I
did not follow, then I stumbled on it when I was going through Access help
looking for something else, but I can't find it in help anymore. Anyone have
specific instructions on how to do this? Or the correct words to use in
Access help to get a hit that will describe how to do it?

You can have the report prompt the user for criteria using a form. See
Report Selection Techniques at:
http://www.jstreettech.com/cartgenie/pg_developerDownloads.asp

Armen Stein
Microsoft Access MVP
www.JStreetTech.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top