T
That Secretary
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.
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.