Week Number

[Sharon Hague]

Hi All

I have a query which is based on a table.

One of my fields in my table is called MyDate.

From this date field I want to create another field in my query to display the week number.

Is this possible?

Please advise.

 

[Mile-O]

NewField: Format([MyDate], "ww")

 

[Sharon Hague]

Mile-O-Phile

This works well but when I try and filter on the week number it only filters on the actual date.

How can I prevent this so that my query displays records for all the dates in that week number?

 

[Sharon Hague]

Thanks Pat that's worked a treat.

Cheers