[AccessD] return query result into variable

Hi group,

i'm using A2k. I need to return the value of a query
into a variable but I cannot rememeber/find the
correct syntax.

I've got a query: qryNewProjectID. It returns ONE
number.

I want something like this:
dim intNewProjectID as Integer
intNewProjectID = docmd.runquery "qryNewProjectID"
msgbox intNewProjectID
How do I do this?

Regards,

Sander

__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com