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
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