G
Guest
I have an Attendance table that has 1 entry for every time a person in late
or absent. I have a query in design mode that takes the date of the
occurrance and formats an interval week so I can do grouping much later down
stream. My problem is that mgmt decided that all of our reporting should end
(this year only) on 10/31/07. This is a wednesday and in the middle of the
week of 0744. They want 11/01/07, 11/02, and 11/03 to be included with 0745.
I tried the following:
AttendWeek & Year:
IIf([Attend-date]>'10/31/07'<'11/04/07','0745',[AttendWeek & Year1]) where
AttendWeek & Year1 is the Interval week. This gives me error 3122.
Ideas?
or absent. I have a query in design mode that takes the date of the
occurrance and formats an interval week so I can do grouping much later down
stream. My problem is that mgmt decided that all of our reporting should end
(this year only) on 10/31/07. This is a wednesday and in the middle of the
week of 0744. They want 11/01/07, 11/02, and 11/03 to be included with 0745.
I tried the following:
AttendWeek & Year:
IIf([Attend-date]>'10/31/07'<'11/04/07','0745',[AttendWeek & Year1]) where
AttendWeek & Year1 is the Interval week. This gives me error 3122.
Ideas?