I'm working in crystal but can use access if you tell me what to do-
I have a report that groups the student's name and lists their attendance dates that month. The number of records vary's by student as do the dates which will all be between 1 and 31 of the same month.
I have to mimic a government form that has a grid from 1 to 31. The attendance date has to go in the appropriate box and if there was no record that day the box has to be blank.
I don't have to (thank the lord) print it onto their form, but if the student has 3 records, May 1, May 4 and May 7 the output of the report has to be
1 5/1
2
3
4 5/4
5
6
7 5/7
8
9
all the way down to 31
this is making me crazy. i have never worked with individual records in the recordset and don't know where to start; besides making me crazy, its frustrating the heck out of me
I have a report that groups the student's name and lists their attendance dates that month. The number of records vary's by student as do the dates which will all be between 1 and 31 of the same month.
I have to mimic a government form that has a grid from 1 to 31. The attendance date has to go in the appropriate box and if there was no record that day the box has to be blank.
I don't have to (thank the lord) print it onto their form, but if the student has 3 records, May 1, May 4 and May 7 the output of the report has to be
1 5/1
2
3
4 5/4
5
6
7 5/7
8
9
all the way down to 31
this is making me crazy. i have never worked with individual records in the recordset and don't know where to start; besides making me crazy, its frustrating the heck out of me