Please Help Me!

[napjones]

I have an attendance table that keeps track of absences and tardies. What I want to do is create a report that counts the number of absences and tardies within a specific date range. I can get it to total up the number of absences and tardies if I leave the date field out of the query, but when I add the date field it seperates the results by date. for example.
Name date Absent Tardy
Adam Ant 1/1/01 0 1
Adam Ant 1/2/01 0 1
Adam Ant 1/3/01 1 0


All I want is it to give me the total for the given date range like this

Name Absent Tardy
Adam Ant 1 2


I know how to get these results in VBA, but I dont know how to make a report for 200 in vba because I can only get it to display 1 record.

 

[Rickster57]

report

Group the report by name using header and footer and add the absenses, etc up that way. In the detail section place the absenses field, then add a text box, set it's source to absenses and Running Sum to Over Group.(call this text box text10). In the group footer add another text box and set it's source to [text10]