Automatically create report??

[essseeproductions]

Hi,

I was wondering if the following is possible:

I have a table which contains about 30 different shop items. What i
wanted is to create a macro which when clicked would automatically
create a report on each item (thats 30 seperate reports) and then
print them off.
Is there anyway this can be possibly done??

Many thanks in advance for all help recieved.

 

[Guest]

Hi

Don't think so.

Access would have no way of knowing which fields you wanted to include. Any
sums you needed, what to include in the header/footer, etc etc etc.

You would be better making the report and then codeing a button to run the
report filtered to your needs. This could include one or all of your shop
items.

 

[essseeproductions]

Right,
So what would this codeing button do?
As the above cannot be done, the next best alternative is a report
that will update on the click of a button maybe as data changes over
time in the fields? Is this what you mean by the codeing of a button?

 

[Guest]

HI

You couldrun the report from a query with perameter values for either month
- start/end dates, etc

I would suggest codeing the button to open the report based on the cuurent
record on a form.

Have a go and if you have specific questions post them here and most people
will be able to answer

 

[essseeproductions]

This way when the database updates will the data in the report update
or is this simply not possible. For example prices change of the items
threfore the price report should change when the prices data is
changed??

 

[raskew via AccessMonster.com]

Hi -

If you've got a bunch of different shop items, and want a separate report on
each, then set your Force New Page property in the detail section to After
Section. That way you'll get a separate page for each shop item.

Bob