Hi Guys
Can someone please help me with a problem with my reports in access 2007.

I have designed a database that stores information on my book collection.
There is a table to record the books and separate tables to record the Publisher and The topic of the book.
On the main switchboard i have a form that lets me input the book data, and i have set up 2 combo box’s to look up details of the table with the publisher and the table with the topic so i just have to click on the data i want to input in the combo box.

My question is how do i get a report to print the information i added via the combo box, all i can get is a list of numbers.

Can someone please help me

Regards Edward

Sounds like you need to base your report on a query that includes both tables joined together by their common field. That will enable you to return the appropriate values from both tables.

Ok thanks i will give that a try

regards to you all