Reports in Access

[Guest_imported]

Hi everyone. I'm creating a report in access using data from a few tables. I have a general table and a book table which are linked together by relationship using the Call Number field. The general table is the primary table. The problem i'm running into is that it is possible to have more than one book with the same call number. What I mean is that whenever there are three books with the same call number the report reprints ALL the data in the general table over again three times. How do I make a report that will see that if there are 3 books with the same call number to just include them in the same report. Thanks Someone told me to use the sorting/grouping option but it's not working like i wanted it to. It still prints each book seperately with all the information printed over again.

Short example

GENERAL REPORT
Book Number: 0502205
Book Name: Silly Goose
Author: Samuel Douglas

GENERAL REPORT
Book Number: 0502205
Book Name: Silly Geese Attack
Author: Samuel Douglas

GENERAL REPORT
Book Number: 0502205
Book Name: Silly Gooses II
Author: Samuel Douglas

...***That is what access is printing in its reports, what I want it to look like is followed below...***

GENERAL REPORT
Book Number: 0502205
Book Name: Silly Goose
Book Name: Silly Geese Attack
Book Name: Silly Gooses II
Author: Samuel Douglas

 

[BoxHead]

I'm sorry, but it really seems like a sorting and grouping issue. Would suggest using the wizard to build the report and make different selections when you get to the grouping screen to see what sortof affect you can have o the report.

Good luck.

BoxHead.

 

[davidd]

I would create a query using the 2 tables and establish the relationship. Your General Table is the primary so take the Call Number for that table and other information you need for the primary table or your Book Table.

In your report you can use the "hide Duplicates" if the call number repeat.

HTH

 

[Telsa]

In a query, you can set its properties to show unique values or records (Do this in the Design Mode of a Select query by right clicking in area above grid and changing values there). Then you can use that query for your report. I always check to see what my query's output looks like first before putting it into a report format. Mary

Rule 1: Don't sweat the small stuff.
Rule 2: EVERYTHING is small stuff!! X-)