R
RSW1127
We recently upgraded to Access 2002-2003, and this query used to work. It now
returns 'Invalid use of null"
INSERT INTO [Agency Payee List] ( ACCOUNT, LOCATION, NAME, CODE9997cur )
SELECT DISTINCT payout.CKPAYEE, payout.CKPAYEELOC, payout.CKAGYNAME,
payout.CKFEDLOC
FROM payout LEFT JOIN [Agency Payee List] ON (payout.CKPAYEELOC=clng([Agency
Payee List].LOCATION)) AND (payout.CKPAYEE=clng([Agency Payee List].ACCOUNT))
WHERE (((payout.CKAGYTYP1)=100) And (([Agency Payee List].LOCATION) Is Null));
returns 'Invalid use of null"
INSERT INTO [Agency Payee List] ( ACCOUNT, LOCATION, NAME, CODE9997cur )
SELECT DISTINCT payout.CKPAYEE, payout.CKPAYEELOC, payout.CKAGYNAME,
payout.CKFEDLOC
FROM payout LEFT JOIN [Agency Payee List] ON (payout.CKPAYEELOC=clng([Agency
Payee List].LOCATION)) AND (payout.CKPAYEE=clng([Agency Payee List].ACCOUNT))
WHERE (((payout.CKAGYTYP1)=100) And (([Agency Payee List].LOCATION) Is Null));