DCount

[Guest]

Hello all,

Can you use two criteria's in a DCount?
I'm wanting something like this.

vCnt = DCount("[wave]", "viaware_cm_f", (((WAVE)=""" & vWave & """) AND
((LOC)like""AFR*"")))"

 

[Alex Dybenko]

yes, you can
but looks like you added too much extra brackets, difficult to read:

(WAVE=""" & vWave & """) AND (LOClike""AFR*"")"

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Duane Hookom]

The "where" argument is usually enclosed in quotes. I would expect something
like:
vCnt = DCount("[wave]", "viaware_cm_f", "[WAVE]=""" & vWave & """ AND [LOC]
like 'AFR*' ")