Report Help

[Mike]

Grrr i've been trying for days, dling templates and trying to copy but i'm
having no luck at all.

i want to create a report that will be sent to alot of people.

It's gunna have my name, phone number, address, company name and a message

and then it's going to have a customers name and date

i want my name,#, address etc. to stay the same (but be able to update it
all in one shot if someone else is using my report)

but i want the customer's name and date to change

ex.

Date:January 1st, 2008
To: Customer

From:My Name
Tele:123-4678
Company: ABC company

i tryed making tables, queries, forms, but when i turn them into reports, it
all comes up on one report in a list, i want a seperate report for each
customer so i can print them and send them

right now my relationship looks like

NameID (auto)<-- SupplierNameID (auto)
Tele -- - -->NameID Supplier Name
Fax SupplierID <-------> SupplierID (auto)
Company Name

sorry for the super long question also is there anyway to add a border or a
perminant picture to every report? i added a drawn border tht i copyed and
pasted from word but it disappeared when i clicked next record

 

[Mike]

hey, don't worry about tht border question, the stuff you do draw in the
table always stays in the Classroom management database (i dled from
http://office.microsoft.com/en-us/templates/TC010184071033.aspx) i just don't
get how they make the student schedules so perfect, like you can click next
record, next record, mine always comes up on one page

 

[Mike]

i found an old database of mine and just copyed the tables over from it so it
worked, but i'm still wondering.... what i did to make it work so that
instead of everything coming up in one list, it comes up on different pages
-> ex sorted by date
(so there'd be a list of things you do on each date, and a different date on
each page)