Fill in Weekdays on Reports

[GitarJake]

Hello all,

I need a report that will display calendar weekends, i.e.:


Saturday 10/18/03
Data,data,data,data

Sunday 10/19/03
Data,data,data,data

Saturday 10/25/03
Data,data,data,data

Sunday 10/26/03
Data,data,data,data

Or maybe even a calandar control that I can fill in. As you can tell, I'm
lost. How can I do this?

TIA

Jake

 

[Ken Snell]

Not sure of what you're trying to do, but you can use the DatePart function
to identify if a date is a Saturday or Sunday:

If DatePart("w", DateFieldName, vbSaturday) = 1 Or _
DatePart("w", DateFieldName, vbSaturday) = 2 Then
' this is a Saturday or a Sunday
End If

 

[Duane Hookom]

It would help if you provided your table and field names and some sample
data. There is a download of a sample calendar report at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4