Saturday, March 1, 2014

Help with Converting an Access query


What about this one with a WHERE clause:



SELECT TBL_MONTH.L_Month, TBL_MONTH.L_MonthName
FROM TBL_MONTH LEFT JOIN TBL_SIGNOFF ON TBL_MONTH.L_Month = TBL_SIGNOFF.SO_Month
AND TBL_SIGNOFF.SO_YEAR=@cboyear AND TBL_SIGNOFF.SO_LOCATION=@tmpVarUserLOC
WHERE TBL_SIGNOFF.SO_Month IS NULL;



Thank you very much. That also works as well.


Appreciate all the help everyone.


No comments:

Post a Comment