duplicate entries

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
Click to expand...
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?
 
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
Click to expand...
duplicates in the query? Thanks
 
Back
Top