Duplicated records

Q

Question

i did a qry, but in one colum the records are duplicate. i want no show those
record, how i can do.

my SQL

SELECT dbo_CMC_PDVC_VAR_COMP.PDPD_ID, dbo_CMC_PDVC_VAR_COMP.PDVC_EFF_DT,
dbo_CMC_PDVC_VAR_COMP.PDVC_PR_PCP, dbo_CMC_PDVC_VAR_COMP.PDVC_PR_IN,
dbo_CMC_PDVC_VAR_COMP.PDVC_PR_PAR, dbo_CMC_PDVC_VAR_COMP.PDVC_PR_NONPAR,
dbo_CMC_PDVC_VAR_COMP.PDVC_PC_NR, dbo_CMC_PDVC_VAR_COMP.PDVC_PC_OBT,
dbo_CMC_PDVC_VAR_COMP.PDVC_PC_VIOL, dbo_CMC_PDVC_VAR_COMP.PDVC_REF_NR,
dbo_CMC_PDVC_VAR_COMP.PDVC_REF_OBT, dbo_CMC_PDVC_VAR_COMP.PDVC_REF_VIOL,
dbo_CMC_PDVC_VAR_COMP.PDVC_LOBD_PTR, dbo_CMC_PDVC_VAR_COMP.SEPY_PFX,
dbo_CMC_PDVC_VAR_COMP.DEDE_PFX, dbo_CMC_PDVC_VAR_COMP.LTLT_PFX,
dbo_CMC_PDVC_VAR_COMP.DPPY_PFX, dbo_CMC_PDVC_VAR_COMP.CGPY_PFX
FROM dbo_CMC_PDVC_VAR_COMP
WHERE (((dbo_CMC_PDVC_VAR_COMP.PDPD_ID)="010MM001") AND
((dbo_CMC_PDVC_VAR_COMP.PDVC_TYPE)=" ") AND
((dbo_CMC_PDVC_VAR_COMP.PDVC_TERM_DT)=#12/31/9999#));
 
J

Jeff Boyce

It appears you are not joining any tables together in your query, so I'm
guessing your underlying data has more than one row that satisfies your
criteria.

Regards

Jeff Boyce
<Access MVP>
 
Top