Get Parameter Popup when trying to run

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am having a problem when I try to run this append query, I keep getting a
pop up for a parameter query in DDAYS and I can't figure out what I have done
wrong. It was working well and then I corrected the dates to make sense and
it hasn't worked since. Can anyone see the obvious, Thanks

INSERT INTO [UNION DUES BY MONTH] ( EMPLOYEE, NAME, DUES, INITIATION, [BACK
DUES], [CK DATE], SIN, [POINT HIRE], [UNION CODE], DDAYS, DUESDATE, WKDAYS )
SELECT dbo_PM_EARNINGS.EMPLOYEE, dbo_PM_EMPMASTER.NAME,
IIf(dbo_PM_EARNINGS!CLASS_05<1,-dbo_PM_EARNINGS!CLASS_05,0) AS DUES,
IIf(dbo_PM_EARNINGS!CLASS_06<1,-dbo_PM_EARNINGS!CLASS_06,0) AS INITIATION,
IIf(dbo_PM_EARNINGS!CLASS_51<1,-dbo_PM_EARNINGS!CLASS_51,0) AS [BACK DUES],
dbo_PM_EARNINGS.CHEQUE_DATE, dbo_PM_EMPMASTER.SIN,
dbo_PM_EMPMASTER.POINT_HIRE, dbo_PM_EMPMASTER.UNION_CODE,
CStr(Format([dbo_PM_EARNINGS]![CHEQUE_DATE],"00-00-00")) AS DDAYS,
DateAdd("d",-7,[DDAYS]) AS DUESDATE, IIf([CLASS_05]<-50,"NO","YES") AS WKDAYS
FROM dbo_PM_EARNINGS INNER JOIN dbo_PM_EMPMASTER ON dbo_PM_EARNINGS.EMPLOYEE
= dbo_PM_EMPMASTER.EMPLOYEE
WHERE (((dbo_PM_EARNINGS.CHEQUE_DATE)>"20051231") AND
((dbo_PM_EMPMASTER.POINT_HIRE) Is Not Null) AND ((DateAdd("d",-7,[DDAYS]))
Between ([Forms]![Union Dues report form]![STDATE]) And ([Forms]![Union Dues
report form]![ENDDATE])) AND ((dbo_PM_EARNINGS.PROV_STATE)<>"BC"));
 
Well, the obvious question to be asked, is the DDAYS field exist in any of
the tables in the select part, not the insert
 
No; it is the one that takes the date and formats it for the other information.

Ofer said:
Well, the obvious question to be asked, is the DDAYS field exist in any of
the tables in the select part, not the insert

--
\\// Live Long and Prosper \\//
BS"D


Akrt48 said:
I am having a problem when I try to run this append query, I keep getting a
pop up for a parameter query in DDAYS and I can't figure out what I have done
wrong. It was working well and then I corrected the dates to make sense and
it hasn't worked since. Can anyone see the obvious, Thanks

INSERT INTO [UNION DUES BY MONTH] ( EMPLOYEE, NAME, DUES, INITIATION, [BACK
DUES], [CK DATE], SIN, [POINT HIRE], [UNION CODE], DDAYS, DUESDATE, WKDAYS )
SELECT dbo_PM_EARNINGS.EMPLOYEE, dbo_PM_EMPMASTER.NAME,
IIf(dbo_PM_EARNINGS!CLASS_05<1,-dbo_PM_EARNINGS!CLASS_05,0) AS DUES,
IIf(dbo_PM_EARNINGS!CLASS_06<1,-dbo_PM_EARNINGS!CLASS_06,0) AS INITIATION,
IIf(dbo_PM_EARNINGS!CLASS_51<1,-dbo_PM_EARNINGS!CLASS_51,0) AS [BACK DUES],
dbo_PM_EARNINGS.CHEQUE_DATE, dbo_PM_EMPMASTER.SIN,
dbo_PM_EMPMASTER.POINT_HIRE, dbo_PM_EMPMASTER.UNION_CODE,
CStr(Format([dbo_PM_EARNINGS]![CHEQUE_DATE],"00-00-00")) AS DDAYS,
DateAdd("d",-7,[DDAYS]) AS DUESDATE, IIf([CLASS_05]<-50,"NO","YES") AS WKDAYS
FROM dbo_PM_EARNINGS INNER JOIN dbo_PM_EMPMASTER ON dbo_PM_EARNINGS.EMPLOYEE
= dbo_PM_EMPMASTER.EMPLOYEE
WHERE (((dbo_PM_EARNINGS.CHEQUE_DATE)>"20051231") AND
((dbo_PM_EMPMASTER.POINT_HIRE) Is Not Null) AND ((DateAdd("d",-7,[DDAYS]))
Between ([Forms]![Union Dues report form]![STDATE]) And ([Forms]![Union Dues
report form]![ENDDATE])) AND ((dbo_PM_EARNINGS.PROV_STATE)<>"BC"));
Click to expand...
Click to expand...
 
Back
Top