Repeated data

[Guest]

I am trying to perfect a database in which I maintain all information
pertaining to attendees signed up for our scheduled seminars. I have created
a form to enter information into the "registration table". I have seminars
and information pertaining to them in a "seminar table". I have created a
query to which links information about each seminar to companies signed up
for that specific seminar. I have created a report that dispalys information
by seminar and then by company. Attendee names, paid checkbox, and other
checkboxes are listed in the detail section beneath the company header. The
information I need is there, however, the attendee names and checkboxes are
repeated 20 times. I tried going into the properties on all these fields and
selecting "yes" next to "hide duplicates", but now one set of said repeated
information is duplicated on six pages. On the four pages in between it is
the only information on the page. The problem only occurs for companies
attending one particular seminar.

 

[Guest]

Sounds like you may not have the correct join between tables.

Table Seminars has fields seminarID,seminarName
Table Registration has fields seminarID, companyName, attendeeName, paid

Query on which report should be based is:

SELECT Seminars.seminarName, registration.companyName,
registration.attendeeName, registration.paid
FROM registration LEFT JOIN Seminars ON registration.seminarID =
Seminars.seminarID;

 

[Guest]

Thank you for your help. Because of your comments, I discovered that my
report was actually based on my registration table...instead of the query. I
changed that and then made the appropriate changes to the query. Thanks! I
probably never would have realized my error...since their names are so
similar!