Thanks Lynn:)

I got this working but was not sure of the reason. Is it also the case that I can't getdate() directly as an input parameter, as in:

exec procname getdate()

MS has some simple step by step articles for upsizing from Access to SQL, and there is a wizard in Access that will do it almost automatically. All the Access/Jet...