I am getting this error:
Syntax Error (missing operator) in query expression
*-- = Start of the expression
--* = End of the expression
PARAMETERS [Begin Date] DateTime, [End Date] DateTime;
SELECT dbo_BIBUDINFO.DEPARTMNT, dbo_BIBUDINFO.DESCRIPTN, dbo_BIBUDINFO.BUDGETAMT, dbo_GL00100.ACTNUMBR_2,
dbo_GL00100.ACTNUMBR_3, dbo_GL20000.REFRENCE, dbo_GL20000.TRXDATE, dbo_GL20000.ORMSTRNM, dbo_GL20000.DEBITAMT
FROM (dbo_BIBUDINFO
INNER JOIN dbo_GL00100 ON dbo_BIBUDINFO.DEPARTMNT = dbo_GL00100.ACTNUMBR_2)
INNER JOIN dbo_GL20000 ON dbo_GL00100.ACTINDX = dbo_GL20000.ACTINDX
WHERE (((dbo_BIBUDINFO.DEPARTMNT)>'019') AND ((dbo_GL00100.ACTNUMBR_2)<>'026' And (dbo_GL00100.ACTNUMBR_2)<>'031' And
(dbo_GL00100.ACTNUMBR_2)<>'041' And (dbo_GL00100.ACTNUMBR_2)<>'102' And (dbo_GL00100.ACTNUMBR_2)<>'123') AND
((dbo_GL00100.ACTNUMBR_3)>'2000') AND ((dbo_GL20000.TRXDATE) Between [Begin Date] And [End Date]) AND
((dbo_GL20000.DEBITAMT)<>0))
UNION ALL SELECT dbo_BIBUDINFO.DEPARTMNT,dbo_BIBUDINFO.DESCRIPTN, dbo_BIBUDINFO.BUDGETAMT, dbo_GL00100.ACTNUMBR_2,
dbo_GL00100.ACTNUMBR_3, dbo_PM30200.TRXDSCRN, dbo_PM30600.PSTGDATE, dbo_PM00200.VENDNAME, dbo_PM30600.DEBITAMT *--
FROM (dbo_BIBUDINFO
INNER JOIN dbo_GL00100 ON dbo_BIBUDINFO.DEPARTMNT = dbo_GL00100.ACTNUMBR_2)
INNER JOIN dbo_PM30600 ON dbo_GL00100.ACTINDX = dbo_PM30600.DSTINDX
INNER JOIN dbo_PM00200 ON dbo_PM30600.VENDORID = dbo_PM00200.VENDORID
INNER JOIN dbo_PM30200 ON dbo_PM00200.VENDORID = dbo_PM30200.VENDORID AND dbo_PM30200.VCHRNMBR = dbo_PM30600.VCHRNMBR --*
WHERE (((dbo_BIBUDINFO.DEPARTMNT)>'019') AND ((dbo_GL00100.ACTNUMBR_2)<>'026' And (dbo_GL00100.ACTNUMBR_2)<>'031' And
(dbo_GL00100.ACTNUMBR_2)<>'041' And (dbo_GL00100.ACTNUMBR_2)<>'102' And (dbo_GL00100.ACTNUMBR_2)<>'123') AND
((dbo_GL00100.ACTNUMBR_3)>'2000') AND ((dbo_PM30600.PSTGDATE) Between [Begin Date] And [End Date]) AND
((dbo_PM30600.DEBITAMT)<>0));
Any help would be great, thanks.
John-
Syntax Error (missing operator) in query expression
*-- = Start of the expression
--* = End of the expression
PARAMETERS [Begin Date] DateTime, [End Date] DateTime;
SELECT dbo_BIBUDINFO.DEPARTMNT, dbo_BIBUDINFO.DESCRIPTN, dbo_BIBUDINFO.BUDGETAMT, dbo_GL00100.ACTNUMBR_2,
dbo_GL00100.ACTNUMBR_3, dbo_GL20000.REFRENCE, dbo_GL20000.TRXDATE, dbo_GL20000.ORMSTRNM, dbo_GL20000.DEBITAMT
FROM (dbo_BIBUDINFO
INNER JOIN dbo_GL00100 ON dbo_BIBUDINFO.DEPARTMNT = dbo_GL00100.ACTNUMBR_2)
INNER JOIN dbo_GL20000 ON dbo_GL00100.ACTINDX = dbo_GL20000.ACTINDX
WHERE (((dbo_BIBUDINFO.DEPARTMNT)>'019') AND ((dbo_GL00100.ACTNUMBR_2)<>'026' And (dbo_GL00100.ACTNUMBR_2)<>'031' And
(dbo_GL00100.ACTNUMBR_2)<>'041' And (dbo_GL00100.ACTNUMBR_2)<>'102' And (dbo_GL00100.ACTNUMBR_2)<>'123') AND
((dbo_GL00100.ACTNUMBR_3)>'2000') AND ((dbo_GL20000.TRXDATE) Between [Begin Date] And [End Date]) AND
((dbo_GL20000.DEBITAMT)<>0))
UNION ALL SELECT dbo_BIBUDINFO.DEPARTMNT,dbo_BIBUDINFO.DESCRIPTN, dbo_BIBUDINFO.BUDGETAMT, dbo_GL00100.ACTNUMBR_2,
dbo_GL00100.ACTNUMBR_3, dbo_PM30200.TRXDSCRN, dbo_PM30600.PSTGDATE, dbo_PM00200.VENDNAME, dbo_PM30600.DEBITAMT *--
FROM (dbo_BIBUDINFO
INNER JOIN dbo_GL00100 ON dbo_BIBUDINFO.DEPARTMNT = dbo_GL00100.ACTNUMBR_2)
INNER JOIN dbo_PM30600 ON dbo_GL00100.ACTINDX = dbo_PM30600.DSTINDX
INNER JOIN dbo_PM00200 ON dbo_PM30600.VENDORID = dbo_PM00200.VENDORID
INNER JOIN dbo_PM30200 ON dbo_PM00200.VENDORID = dbo_PM30200.VENDORID AND dbo_PM30200.VCHRNMBR = dbo_PM30600.VCHRNMBR --*
WHERE (((dbo_BIBUDINFO.DEPARTMNT)>'019') AND ((dbo_GL00100.ACTNUMBR_2)<>'026' And (dbo_GL00100.ACTNUMBR_2)<>'031' And
(dbo_GL00100.ACTNUMBR_2)<>'041' And (dbo_GL00100.ACTNUMBR_2)<>'102' And (dbo_GL00100.ACTNUMBR_2)<>'123') AND
((dbo_GL00100.ACTNUMBR_3)>'2000') AND ((dbo_PM30600.PSTGDATE) Between [Begin Date] And [End Date]) AND
((dbo_PM30600.DEBITAMT)<>0));
Any help would be great, thanks.
John-