Thanks Steve & noeld.

Steve - I'll add the table aliases and check out CAST (do you have a good URL for that handy?)

Noeld - yes - the app is running now fine in Access, and I will keep this one there. I'm just trying to convert it into tsql to see what changes I'd need to make in future projects.

Steve