Avoiding duplicates - HELP!!

F

FarmboyDave

our DB lists codes associated with unique orders. I created a table that has
a field that should contain a standard description of the codes (the
JeopardyCodes.JeopArea below). Each order might have up to 20 codes at
various stages of the order fulfillment. Problem is that when I run the query
to populate the blank fields the db creates a new record for each code that
it finds? how do I avoid this. Oh - the table that contains the descriptions
is really just a list so it cannot be joined to the "orders table" My query
looks like this:

SELECT DISTINCT DN_WIPCNR_Jeop_Dtl_Table.[Order ID],
DN_WIPCNR_Jeop_Dtl_Table.CSM, DN_WIPCNR_Jeop_Dtl_Table.Customer,
DN_WIPCNR_Jeop_Dtl_Table.[Service Type], DN_WIPCNR_Jeop_Dtl_Table.OM,
DN_WIPCNR_Jeop_Dtl_Table.[Proj Init], DN_WIPCNR_Jeop_Dtl_Table.[CR Status],
DN_WIPCNR_Jeop_Dtl_Table.[SR Status], DN_WIPCNR_Jeop_Dtl_Table.[Sub Status],
DN_WIPCNR_Jeop_Dtl_Table.[Ord Status], IIf([DN_WIPCNR_Jeop_Dtl_Table.Proj
IitCoe Jeop]=[JeopardyCodes.JeopCode],[JeopardyCodes.JeopArea]) AS Ind1,
DN_WIPCNR_Jeop_Dtl_Table.[Proj IitCoe Jeop],
IIf([DN_WIPCNR_Jeop_Dtl_Table.Proj Init
Jeop]=[JeopardyCodes.JeopCode],[JeopardyCodes.JeopArea]) AS Ind2,
DN_WIPCNR_Jeop_Dtl_Table.[Proj Init Jeop],
IIf([DN_WIPCNR_Jeop_Dtl_Table.KickOffEnblmnt
Jeop]=[JeopardyCodes.JeopCode],[JeopardyCodes.JeopArea]) AS Ind3,
DN_WIPCNR_Jeop_Dtl_Table.[KickOffEnblmnt Jeop],
IIf([DN_WIPCNR_Jeop_Dtl_Table.Sch VOIP TQ
Jeop]=[JeopardyCodes.JeopCode],[JeopardyCodes.JeopArea]) AS Ind4,
DN_WIPCNR_Jeop_Dtl_Table.[Sch VOIP TQ Jeop],
IIf([DN_WIPCNR_Jeop_Dtl_Table.Cond VoipTQ
Jeop]=[JeopardyCodes.JeopCode],[JeopardyCodes.JeopArea]) AS Ind5,
DN_WIPCNR_Jeop_Dtl_Table.[Cond VoipTQ Jeop],
IIf([DN_WIPCNR_Jeop_Dtl_Table.BVOIP TT
Jeop]=[JeopardyCodes.JeopCode],[JeopardyCodes.JeopArea]) AS Ind6,
DN_WIPCNR_Jeop_Dtl_Table.[BVOIP TT Jeop], IIf([DN_WIPCNR_Jeop_Dtl_Table.Sched
TT Jeop]=[JeopardyCodes.JeopCode],[JeopardyCodes.JeopArea]) AS Ind7,
DN_WIPCNR_Jeop_Dtl_Table.[Sched TT Jeop], IIf([DN_WIPCNR_Jeop_Dtl_Table.TT
Warn Jeop]=[JeopardyCodes.JeopCode],[JeopardyCodes.JeopArea]) AS Ind8,
DN_WIPCNR_Jeop_Dtl_Table.[TT Warn Jeop], DN_WIPCNR_Jeop_Dtl_Table.Age,
DN_WIPCNR_Jeop_Dtl_Table.Action
FROM JeopardyCodes, DN_WIPCNR_Jeop_Dtl_Table;
 
Top