I have the following DCount expression in my MS Access Query but it's not quite working how I want it to:
It seems to be counting all the WIDates before / equal to the WIDate that the query calls up rather than just the ones associated with the specific MemberNo.Code:DCount("MemberNo","Recs","Recs.WIDate<=WIDate AND MemberNo=" & Recs.MemberNo)
Any ideas please? It's probably something *really* simple - like a misplaced quotation mark - but I just can't figure it out
Thanks in advance!