Duplicate number

A

Allison

How can I remove a duplicate number in a column before a run a select query?

This is an example of the column

56381 1527.00
56381 1527.00
98631 1829.31
98761 1821.00
77552 2354.11
77552 2354.11
 
D

Douglas J. Steele

You could try simply putting the word DISTINCT into your SQL (or, if you're
using the visual query builder, setting the query's UniqueValues property to
Yes.) This assumes that the entire row (at least for the fields you're
selecting) is the same.
 
A

Allison

Doug,

In the SQL layout BELOW where do I put this information about DISTINCT?

SELECT LINK_QVR_QVR_DOWNLOAD_CAN_V.APPL_ID, PUBLIC_PV_BUDGET.FULL_GRANT_NUM,
LINK_QVR_QVR_DOWNLOAD_CAN_V.ADMIN_PHS_ORG_CODE,
LINK_QVR_QVR_DOWNLOAD_CAN_V.FY, LINK_QVR_QVR_DOWNLOAD_CAN_V.SERIAL_NUM,
LINK_QVR_QVR_DOWNLOAD_CAN_V.COUNCIL_MEETING_DATE,
Trim([Public_PV_Budget.PERIOD_TYPE_CODE]) AS PERIOD,
LINK_QVR_QVR_DOWNLOAD_CAN_V.PI_NAME,
LINK_QVR_QVR_DOWNLOAD_CAN_V.PROJECT_TITLE,
LINK_QVR_QVR_DOWNLOAD_CAN_V.PROG_CLASS_CODE,
LINK_QVR_QVR_DOWNLOAD_CAN_V.RFA_PA_NUMBER,
LINK_QVR_QVR_DOWNLOAD_CAN_V.REQ_YEAR1_AMT

FROM LINK_QVR_QVR_DOWNLOAD_CAN_V RIGHT JOIN PUBLIC_PV_BUDGET ON
LINK_QVR_QVR_DOWNLOAD_CAN_V.APPL_ID = PUBLIC_PV_BUDGET.APPL_ID

WHERE (((LINK_QVR_QVR_DOWNLOAD_CAN_V.ADMIN_PHS_ORG_CODE)="AI") AND
((LINK_QVR_QVR_DOWNLOAD_CAN_V.COUNCIL_MEETING_DATE)="200501") AND
((Trim([Public_PV_Budget.PERIOD_TYPE_CODE]))="CNL"));
 
D

Douglas J. Steele

After the word SELECT:

SELECT DISTINCT LINK_QVR_QVR_DOWNLOAD_CAN_V.APPL_ID, ...

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



Allison said:
Doug,

In the SQL layout BELOW where do I put this information about DISTINCT?

SELECT LINK_QVR_QVR_DOWNLOAD_CAN_V.APPL_ID,
PUBLIC_PV_BUDGET.FULL_GRANT_NUM,
LINK_QVR_QVR_DOWNLOAD_CAN_V.ADMIN_PHS_ORG_CODE,
LINK_QVR_QVR_DOWNLOAD_CAN_V.FY, LINK_QVR_QVR_DOWNLOAD_CAN_V.SERIAL_NUM,
LINK_QVR_QVR_DOWNLOAD_CAN_V.COUNCIL_MEETING_DATE,
Trim([Public_PV_Budget.PERIOD_TYPE_CODE]) AS PERIOD,
LINK_QVR_QVR_DOWNLOAD_CAN_V.PI_NAME,
LINK_QVR_QVR_DOWNLOAD_CAN_V.PROJECT_TITLE,
LINK_QVR_QVR_DOWNLOAD_CAN_V.PROG_CLASS_CODE,
LINK_QVR_QVR_DOWNLOAD_CAN_V.RFA_PA_NUMBER,
LINK_QVR_QVR_DOWNLOAD_CAN_V.REQ_YEAR1_AMT

FROM LINK_QVR_QVR_DOWNLOAD_CAN_V RIGHT JOIN PUBLIC_PV_BUDGET ON
LINK_QVR_QVR_DOWNLOAD_CAN_V.APPL_ID = PUBLIC_PV_BUDGET.APPL_ID

WHERE (((LINK_QVR_QVR_DOWNLOAD_CAN_V.ADMIN_PHS_ORG_CODE)="AI") AND
((LINK_QVR_QVR_DOWNLOAD_CAN_V.COUNCIL_MEETING_DATE)="200501") AND
((Trim([Public_PV_Budget.PERIOD_TYPE_CODE]))="CNL"));


Allison said:
How can I remove a duplicate number in a column before a run a select
query?

This is an example of the column

56381 1527.00
56381 1527.00
98631 1829.31
98761 1821.00
77552 2354.11
77552 2354.11
Click to expand...
Click to expand...
 
Top