Duplicate number

[Guest]

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

 

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

 

[Guest]

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"));

 

[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!)

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"));

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