Retrieve a single value 1

[besto1a]

How do i retreive a signle value use a sql statement in VBA I gace tried the following but it dosent work.

Dim myString as string

myString = db.execute "Select Name from Tbl_Users Where UserID = andrew"

 

[Remou]

You can use DlookUp.

[tt]myString = DlookUp("[Name]","Tbl_Users","UserID = 'andrew'")[/tt]

Name is a reserved word and should not be used as a name for anything.

 

[besto1a]

Thank My example was a simple one just to illustrate my problem. I need to bring back a count of rows where the name is andrew and assign that value to a integer

 

[Remou]

Use DCount. There are several domain aggregate functions.