OTWarrior
11-15-2007, 08:57 AM
I have been asked to modify an existing report (and to do it by 12:00 tomorrow...grrr) to count how much of what data is displayed in the report.
unfortunately the report goes something like this:
Area 1:
Service date cost
service1 01/01/07 ?3.00
service1 01/01/07 ?3.00
Area 2:
Service date cost
service1 01/02/07 ?4.00
service2 01/03/07 ?3.00
Total cost ?10.00
Unfortunely, they want the count of how many services per area there are, along with the total of each service over all areas.
Area 1, Service 1 = 2
Area 2, Service 1 = 1
Area 2, Service 2 = 1
if I count the the "detail" section, it count how many total records there are. if I put it in the "footer", it just counts how many service names are available anyway.
The only way I can think of would be to do the calculation in another qry which is based off this one (counting the records for me) and to bring it in, the problem being as it is not a part of the "linked" qry on the report, it cannot find the value (even though I tell it the exavct qry name)
I have tried:
=[qry_name]![txtField]
Please help.
unfortunately the report goes something like this:
Area 1:
Service date cost
service1 01/01/07 ?3.00
service1 01/01/07 ?3.00
Area 2:
Service date cost
service1 01/02/07 ?4.00
service2 01/03/07 ?3.00
Total cost ?10.00
Unfortunely, they want the count of how many services per area there are, along with the total of each service over all areas.
Area 1, Service 1 = 2
Area 2, Service 1 = 1
Area 2, Service 2 = 1
if I count the the "detail" section, it count how many total records there are. if I put it in the "footer", it just counts how many service names are available anyway.
The only way I can think of would be to do the calculation in another qry which is based off this one (counting the records for me) and to bring it in, the problem being as it is not a part of the "linked" qry on the report, it cannot find the value (even though I tell it the exavct qry name)
I have tried:
=[qry_name]![txtField]
Please help.