Assigning SQL select query to a variable

[neillovell]

In VBA how can I assign the value of a query to a variable?
I've tried
SQL = "SELECT TotalPoints FROM PlayerTable WHERE ID=123"
Points = DatabaseConnection.Execute SQL
MsgBox TotalPoints

but the Points = line is erroring with "syntax Error" - how can I do this?

 

[JoanneM]

hello

a silly question but are you querying a SQL database or a table in access.

I'm guessing SQL - but must check first..
Jo

 

[scriverb]

Create a saved query called qryTotalPoints. Copy and paste your SQL code into the SQL window:

Dim lngPoints as Long
lngPoints = DMax("TotalPoints", "qryTotalPoints&quot
MsgBox lngPoints


Post back with any questions.

Bob Scriver
Want the best answers? See FAQ181-2886
Nobody believes the official spokesman... but everybody trusts an unidentified source.
Author, Bagdad Bob???

 

[neillovell]

Thanks!!!