How do you create a query that will find the last weekday of a given month?
Add a new column to your query (watch line wrap, it's all on one line):
LastWeekdayInMonth:
Weekday(DateSerial(Year([DateField]),Month([DateField])+1,0))
This will return the number that represents the day of the week. If you want to
display the actual name of the day, you could create a table containing the
weekday numbers and their corresponding day names and show this table in your
query. Drag the weekday "name" field onto the grid to create a new column and
set its criteria to (again, watch line wrap):
[tblWeekDays].[DayNum]=Weekday(DateSerial(Year([DateField]),Month([DateField])+1
,0))
Of course, you would need to replace "tblWeekDays" with the name of your weekday
lookup table, "DayNum" with the name of the field in that table that stores the
weekday number and "DateField" with the name of the field in your query that
contains the date field in the query from which the weekday value will be
generated.
