[AccessD] return query result into variable

Hi Sander

The quick method is to use DLookup:

  intNewProjectID = DLookup("[TheField]", "qryNewProjectID")

This will fail for an empty output.
If this can happen use:

  intNewProjectID = Nz(DLookup("[TheField]", "qryNewProjectID"), 0)

/gustav


> 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?