Need a COUNT from db within code

[SCubed]

I need to get the count value back from this sql select statement from my code:

"SELECT count(AssetOwner) " & _
"FROM AssetOwner WHERE AssetOwner = '" & NewAssetOwner.Value & "'"

However, I can't figure out the correct command or syntax to get it. I've tried DoCmd.RunSQL(the above sql statement) and it tells me that "RunSQL requires a SQL statement". I've tried everything I can think of. Please help!

Thank you!

 

[SteveR77]

Take a look at the Dcount function.

It allows you to get the count over your query or table based upon your criteria.


Steve

 

[Nowell]

Hi,

is AssetOwner a field as well as the table name?
Can you post all your code so I can have a look

 

[SCubed]

DCOUNT was exactly what I needed!! Thank you, thank you, thank you!!!

SCubed