Ah hah! Thank you very much!
The specification and examples for "CREATE PROC" is really brief! All the
examples consist of a single statement and I don't see how to pass function
arguments or use multiple statements. I suspect it is not possible.
I tried @@IDENTITY and it seems to work! Where do I find the documentation
on @@IDENTITY? I looked under clauses in
http://office.microsoft.com/en-us/as...526881033.aspx and could
not find it there. I looked under new features and it did not appear to be
there either. I guess Tim answer my question already by refering me to the
TSQL documentation. Is it fair to say @@IDENTITY is not documented in the
Access documenation?
Siegfried