Date Criteria Prob

[Meltdown]

Hi everyone, I have a Date field in a query that is formatted on a weekly basis:
WeeklyDate: Format([Sent_Date],"ww")

...that's fine.

Let's say I only want to see records for week 40, if I put 40 in the Criteria field I get a Data Type Mismatch error. How do I enter a weekly Criteria?

Thanks

 

[Rich]

Try "40 "

 

[Meltdown]

Thanks Rich, Happy New Year.