duplicate entries

[Guest]

I'm trying to create a report of a library list that is separtated by category, and I didn't have a problem doing that but I have all the information about the book in one table, and the authors in another table. My problem is that, say I have two authors for one book, it lists both authors names twice. I obviously only need the author listed one time in the report. What am I doing wrong that the authors name is printed more than once in the report? Any ideas?

 

[Bufo Calvin]

Is the report based on a query? You could limit
duplications in the query.

-----Original Message-----
I'm trying to create a report of a library list that is

separtated by category, and I didn't have a problem doing
that but I have all the information about the book in one
table, and the authors in another table. My problem is
that, say I have two authors for one book, it lists both
authors names twice. I obviously only need the author
listed one time in the report. What am I doing wrong that
the authors name is printed more than once in the report?
Any ideas?

 

[Guest]

yes, it is based on a query, so how would I limit duplicates in the query? Thanks

 

[Fons Ponsioen]

In the querry design frame you can activate properties by
dbl clicking in the blank gray space besides the tables,
than in the properties window set unique values to yes.
I addition in the report you set the property for the
textbox to not show duplicate values.
Hope this helps.
Have a great weekend
Fons

-----Original Message-----
yes, it is based on a query, so how would I limit

duplicates in the query? Thanks