And here I thought it would be a simple thing to move this query over to SQL2K...silly me.

I will work through your code and try to fit to my program...have...

Antares suggestions have worked for the IsNull stuff (Thank you!)...  I'm now trying to define the variables for the form field data. as suggested by both Antares and Gary.  If...

Ah...I see where I was going wrong with the IsNull statements!  I will try your suggestions.

Thank you for the very descriptive help! 

The 'Forms.frmImPrintPmtAdvice...' is to reference/pull the data from specific fields in the form.  In the old query, it was 'Forms!' (which, you are correct, is not valid in SQL server..only within the...