Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problems making a report

Status
Not open for further replies.

finberg

Programmer
Aug 23, 2002
27
UA
do have a database a book firm.
There are such tables:
Books, Partners,Orders,Orders details,

I do need to make a report showing by partners which books and when they have ordered.It should look like:

Partner 1

........... .... 23.12.01 25.12.01 22.04.02

1.Book A......2
2.Book B ........................ 2.............. 2
3.Book C......2

The same for each parner (the dates should be the dates of the orders made by this partner and they are uniqe for each of them)

Could you please help me how it could be done.
Thank you
Arseniy
 
finberg,

It looks like you are trying to create a standard report with groupings.

What you would need to do is run a query adding the tables and linking through any primary keys you have. Then run the report wizard which will guide you step by step through the report creation.

If I'm talking jibberish, drop another post and I'll see if I can detail it down for you.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top