R
RJL
I have a table for all of the Events I have to work and what equipment
I need at them. I then have a subevent table if there are multiple
shows at the same location during the same trip. I am then running a
report to determine all of the events that need a specific piece of
equipment. The problem I am having is that my report is returning the
event AND the subevents for a given date and listing each one as
needing that special piece of equipment. So say I have an event in
Charlotte that needs a specific piece of equipment on June 11th. I
also have two more events in Charlotte on the 12th and 13th that also
need that same piece of equipment. So the Event Table would have an
event with an "ID" 0f 315 (autonumbered), a "Name" of RJL Conference,
a "Date" of June 13th and "Equipment" of VX3200. Then in the Subevent
Table there would be a record with "Name" Truck Show, a "Date" of June
11th and "Equipment" of VX3200 and one with a "Name" of Dental Sales
Conference, a "Date" of June 12th and "Equipment" of VX3200. When I
run the query it indicates that I have 3 events that need that
specialized piece of equipment that have the "ID" of 315. I would
like to have either the report or the query not display any events
with the same "ID". Thus it would only show one of the Events with ID
of 315 and delete or hide the others. Below is the description of the
tables I'm using.
Event.Table
ID.Field
Name.Field
Date.Field
Equipment.Field
Subevent.Table (Linked using the primary key (ID.Field) from the
Event.Table)
Name.Field
Date.Field
Equipment.Field
Thanks for your time.
-RJL
I need at them. I then have a subevent table if there are multiple
shows at the same location during the same trip. I am then running a
report to determine all of the events that need a specific piece of
equipment. The problem I am having is that my report is returning the
event AND the subevents for a given date and listing each one as
needing that special piece of equipment. So say I have an event in
Charlotte that needs a specific piece of equipment on June 11th. I
also have two more events in Charlotte on the 12th and 13th that also
need that same piece of equipment. So the Event Table would have an
event with an "ID" 0f 315 (autonumbered), a "Name" of RJL Conference,
a "Date" of June 13th and "Equipment" of VX3200. Then in the Subevent
Table there would be a record with "Name" Truck Show, a "Date" of June
11th and "Equipment" of VX3200 and one with a "Name" of Dental Sales
Conference, a "Date" of June 12th and "Equipment" of VX3200. When I
run the query it indicates that I have 3 events that need that
specialized piece of equipment that have the "ID" of 315. I would
like to have either the report or the query not display any events
with the same "ID". Thus it would only show one of the Events with ID
of 315 and delete or hide the others. Below is the description of the
tables I'm using.
Event.Table
ID.Field
Name.Field
Date.Field
Equipment.Field
Subevent.Table (Linked using the primary key (ID.Field) from the
Event.Table)
Name.Field
Date.Field
Equipment.Field
Thanks for your time.
-RJL