DCount Criteria

[LB79]

Hi All,

I'm having trouble with a DCount – Clearly I've not got it right.
Please can someone advise how I should change this?

Thanks

DCount('MyField','MyTable2','Month=[MyTable1].[Month]')

 

[plog]

Your use of generic names (god I hope they aren't actual names in your database) is making it hard to see exactly what you want to accomplish. My guess is this is what you want:


DCount('MyField','MyTable2','Month=' & [MyTable1].[Month])

If not, post back with actual names, what it is actually returning and what you expect it to return.

 

[LB79]

Thanks Plog thats exactly what I needed.
Sorry for generic names but I can't post anything that might reveal my companies identity.