Filter dates by Saturday

[Jan]

No doubt really simple to someone with the necessary skills.

I have a table with 8 years of data entered daily. The table has four
columns: AgentCode, IssueDate, Quantity and Price.

I need to apply a filter so that only dates that fall on a Saturday are
shown.

Any help will be appreciated.

Thanks
Jan

 

[Rob Parker]

This is simple, using the built-in Weekday function. Build a query, with
each field from your table. Add another calculated field:
DoW:Weekday([IssueDate])
and set its criteria to 7. Uncheck the Show box if you don't want it to
show.

HTH,

Rob