Reports- manipulating records

[litrainer]

I created a report with one student per page and the attendance dates for the month. That's not a problem.

What is the probelm is the customer sinsistes the report be in a grid with the day of the month matching the attendance record.

If the student had attendance on 5/1, 5/5 and 5/7 the out put would be

Student: Baby Joey


1 5/1
2
3
4
5 5/5
6
7 5/7


All the way to 31. Haven't a clue how to do this. I'm not even sure how to ask this.

As an added bonus, the student could have two sessions on the same day and each must be listed (there is more to the attendance record than the date but if I can get a heads up on matching the the date to the day of the month line, I can do the rest.

I thankfully don't have to output to a preprinted form, but I must show 1 to 31 whether the line has attendance data or not.

If there is a shred of compassion out there, please help

 

[Estuardo]

Hello and welcome!
I guess that many people here may be willing to help, but you're telling us your requirement but we know nothing about your db.
I may say: create a table with 31 rows and match the date. Then you'll end up with a report with 31 lines per Attendee... This may work or might be an absurd.
Tell more about your data, or upload your db without any sensitive data. That will help to assist you.