I am using Access 2007 now even though I'm used to using 2003. It's beginning to show how drastically it has changed. I have a query in 2003 where the field for an Attendance query was a custom one with the following syntax:
WeekEnding: DateAdd("d",-Weekday([Day]+7,[Day])
Day is the date of the attendance record and this would generate the date for every saturday in order to print up the attendance reports. In 2007 I go to input that information as the field name and as soon as I hit enter or check the "Show" box, the field name box goes blank. Any ideas?
WeekEnding: DateAdd("d",-Weekday([Day]+7,[Day])
Day is the date of the attendance record and this would generate the date for every saturday in order to print up the attendance reports. In 2007 I go to input that information as the field name and as soon as I hit enter or check the "Show" box, the field name box goes blank. Any ideas?
