Every month my staff is required to count certain activities that may have been started or completed in that month. There are six start fields and six completed fields. These are only for their benefit to provide answers to an external report that is emailed up the chain of command each month. I have forgotten anything that I had learned by trial and error over the last couple of years not doing much with access. I have a simple report from a table that lists each record and the corresponding date field sorted by 3 categories:
counted from 7-29-06 to 8-29-06. I really only need sub totals in each category although report totals would be nice.
category 1
id# start1 start2 start3 completed1 completed2 completed3 etc
id 1 7-14-06 9-1-06 8-12-06
id2 8-13-06 6-1-06 7-13-06
id 3 8-14-06 8-19-06
id 4 8-2-06 8-23-06
tot 2 0 1 2 0 1
I don't know how to get the totals or set the date range for the report.
I believe I should be able to do an unbound controls in the footer area to count each field for a given time frame. I know this is simple and perhaps not the most efficient way to do this but I will be dealing with less than 100 records per staff member which stays resident on their pc. Their info does not need to be saved just inputted into an excel report to be sent in to a division office after their totals are cut an pasted. For their purposes the need to keep track individually of their tasks so inputting on a form that can be monitored when they have client contact.
Please keep in mind I will need to be spoon fed on this.
Thanks
counted from 7-29-06 to 8-29-06. I really only need sub totals in each category although report totals would be nice.
category 1
id# start1 start2 start3 completed1 completed2 completed3 etc
id 1 7-14-06 9-1-06 8-12-06
id2 8-13-06 6-1-06 7-13-06
id 3 8-14-06 8-19-06
id 4 8-2-06 8-23-06
tot 2 0 1 2 0 1
I don't know how to get the totals or set the date range for the report.
I believe I should be able to do an unbound controls in the footer area to count each field for a given time frame. I know this is simple and perhaps not the most efficient way to do this but I will be dealing with less than 100 records per staff member which stays resident on their pc. Their info does not need to be saved just inputted into an excel report to be sent in to a division office after their totals are cut an pasted. For their purposes the need to keep track individually of their tasks so inputting on a form that can be monitored when they have client contact.
Please keep in mind I will need to be spoon fed on this.
Thanks
