Not Show duplicates?

  • Thread starter Thread starter Dustin Swartz
  • Start date Start date
D

Dustin Swartz

I have a quote tracking database for doors and windows.

I need to track the acumulate total of dollar amount quoted in a given
period.

The only problem is that we often quote the same project to multiple
contractors (of which only 1 will win the bid) so my database will contain
multiple entries that I do not want added to the dollar total.

Example

Quote # 1
Qty 10 of Window A, $1200
Qty 3 of Door B, $1400


Quote # 2 (Duplicate of Quote#1)
Qty 10 of Window A, $1200
Qty 3 of Door B, $1400


Quote #3
Qty 2 of Window Z $2300

In my Query I need to detect that Quote 2 is a duplicate and not include the
dollar amounts in my tracking total.

I have 2 Tables

1 Quotes, this table contains the header info for each quote.

2 Quote Items. This table contains a record for each Window or door
quoted.along with the associated quote number.


Any sugggestions on the best way to go about this?

Thank you, Dustin
 
Dustin,

You are a lost cause. I can't believe you don't know how to do that?!

Sincerely,
Access Wizard
 
Back
Top