Help with calculating the last friday of the month in a query

[astron2012]

Hi,

I want to create a query that will bring up data from a table automatically for what we call the working month. This is from the last friday of the previous month + 1 to the last friday of the current month.

Does anyone know how I can write this calculation in the query design mode under the 'MailingDate' field? I would like to use something like the Now() function so the user won't need to enter any dates.

Any help with this would be much appreciated.

Cheers

 

[gblack]

I looked it up and it seems like this might be of help to you:
http://forums.aspfree.com/microsoft...-last-friday-of-a-month-ms-access-203553.html

 

[jdraw]

Double posting is frowned upon. If you do double post at least have the courtesy to inform the reader.
http://www.accessforums.net/queries/help-calculating-last-friday-month-query-25577.html