Filter dates in table that fall on a Saturday

[Jaribu]

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 (IssueDate column) that fall on a Saturday are shown.

Any help will be appreciated.
Thanks!

 

[raskew]

Hi -

Welcome to the forum.

In a query of your table, add a calculated field, e.g.:
Expr1: Weekday([YourDateField]) , then
in that field's criteria cell place 7.

That will return only records where the date fell on a Saturday.

HTH - Bob

 

[Jaribu]

Thanks a million!

Works perfectly.