DCount and Filter using the Format(xx,yy)

[gzuroweste]

I am tring to count the records in a specific time frame. The DCount function works fine in counting the total records, until I try to enter my criteria. It still returns total records. I must be using the wrong syntex.

intX = DCount("[No]", "Turrent", (Format(Me.Date, yy) = Format(Now, yy)))

Any help would be nice.




[This message has been edited by gzuroweste (edited 03-21-2001).]