If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Eliminating Duplicate Records in a Form or Query
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 |
#2
|
|||
|
|||
Eliminating Duplicate Records in a Form or Query
snip
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. Hi, Unless I've misunderstood something, why don't you just remove the subevent table from the report. Marc |
Thread Tools | |
Display Modes | |
|
|