report problem!

[Daniel Hiller]

Hi All,

In my database I have a copy of the invoice which has all mobile phone bills
as one - all of the telephone numbers called, cost etc. I need to be able to
generate a report for each telephone number and email it out.

Currently I have generated a report so it has all calls under each telephone
number

01234 134234
line 1
line 2

01234 134255
line 1
line 2

How do I go about creating seperate reports?? Macro? Call the report passing
different parameters???

Please help!!

Many Thanks,
Daniel

 

[Rod]

Use the report detail to force a new page on change in
tel#. Look under 'Page breaks, adding to reports' in the
MSAccess help.

 

[Daniel Hiller]

Ok, so my report prints out invoices for each telephone number on seperate
pages, but how do i now email out each page to a seperate user??? So a user
on receives a invoice for their telephone number?