A
Ann
I'm trying to get only the distinct rows for the following but it doesn't
work. What am I doing wrong? Thanks for any help you can provide.
SELECT DISTINCTROW tblDRSJobs.txtDRSMonth, tblDRSJobs.txtDRSNumber,
Nz(([curFirstClassPostageRate]*[sngQuantity])+[curDeliveryCost],0) AS
curUSPSPostageCost, Nz([curUSPSPostageCost]-[curPostageStatementCost]) AS
[DiscountedPostageCost/Savings], tblDRSJobsByOperators.txtMachineType INTO
[tblDiscountedPostageCost/Saving]
FROM tblDRSJobs INNER JOIN tblDRSJobsByOperators ON tblDRSJobs.txtDRSNumber
= tblDRSJobsByOperators.txtDRSNumber
WHERE (((tblDRSJobsByOperators.txtMachineType)="SeCap" Or
(tblDRSJobsByOperators.txtMachineType)="Video Jet" Or
(tblDRSJobsByOperators.txtMachineType)="Offline" Or
(tblDRSJobsByOperators.txtMachineType)="DA95"));
work. What am I doing wrong? Thanks for any help you can provide.
SELECT DISTINCTROW tblDRSJobs.txtDRSMonth, tblDRSJobs.txtDRSNumber,
Nz(([curFirstClassPostageRate]*[sngQuantity])+[curDeliveryCost],0) AS
curUSPSPostageCost, Nz([curUSPSPostageCost]-[curPostageStatementCost]) AS
[DiscountedPostageCost/Savings], tblDRSJobsByOperators.txtMachineType INTO
[tblDiscountedPostageCost/Saving]
FROM tblDRSJobs INNER JOIN tblDRSJobsByOperators ON tblDRSJobs.txtDRSNumber
= tblDRSJobsByOperators.txtDRSNumber
WHERE (((tblDRSJobsByOperators.txtMachineType)="SeCap" Or
(tblDRSJobsByOperators.txtMachineType)="Video Jet" Or
(tblDRSJobsByOperators.txtMachineType)="Offline" Or
(tblDRSJobsByOperators.txtMachineType)="DA95"));