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
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