DCount Question (Criteria)

[matthewnsarah07]

A quick question about DCount

I have a table with field [Location], it contains data from a larger databases of where a job occured. I would like to make a count of the number of jobs in certain locations but the location format can change sometimes. Is there a way to specify a criteria whereby certain elements are looked for such as 'M6' & 'J40' and not a complete match?

Thanks

 

[DCrake]

You can use either the Like method using wild cards or use the In() method

Like "M6*" Or Like "J40*"

In("M6","J40")

 

[matthewnsarah07]

And I'm right in thinking this can be used within a DCount Criteria?

Thanks for your help, appreciated

 

[DCrake]

Yes you are correct