report Date

[Nigel09 via AccessMonster.com]

Hi can any one help,

I want to return the dates for a month as follows,

5 June
12 June
19 June
26 June


This is the date for every Friday in that month, is this possable???

 

[Allen Browne]

Filter for the 6th month, and the 6th day of the week.

Substitute your date field name for D in the following:
strWhere = "(Month([D]) = 6) AND (Weekday([D] = 6)"
DoCmd.OpenReport "Report1", acViewPreview, , strWhere