M
Maureen227
Guest
I have a database that contains a CUSTOMER table, an INVOICE table, an EQUIPMENT table and a LABOR table.
The INVOICE table has a 1 to many relationship to the EQUIPMENT and the LABOR table.
The EQUIPMENT table and the LABOR table are grouped by the ROOM in which the equipment is used and the labor is done.
Petty simple stuff, right!!! Wait
I have a report that looks like this
Report header (design view)
Company information
Room Group
txtArea (this is a field in the EQUIPMENT and in the LABOR tables)
Details
Oty description cost extended (fields from EQUIPMENT table)
GroupFooter
LaborDescription Charge (fields from the LABOR table)
Report Footer
Total equipment Cost (=sum(extended) (textbox name for extended cost)
Total Labor Cost =sum(charge)
Amount paid to date (field in payment table)
Balance Due =txtTotalEquip+txtLaborChge)-AmtoDate
The report should print something like this (print preview expected)
Company Info
Invoice #9999999
Room1
1 EquipA $$$$$ $$$$$
1 EquipB $$$$$ $$$$$
Labor $$$$$$
Room2
1 EquipA $$$$$ $$$$$
2 EquipB $$$$$ $$$$$
1 EquipC $$$$$ $$$$$
4 EquipDB $$$$$ $$$$$
Labor $$$$
Room3
Labor $$$$
Total of Equipment $$$$$
Total of Labor $$$$$$
Amount day to date $$$$$
Grand Total $$$$$$
Reasonable Yes!
Here is the problem.
1 The labor line for Room 3 with labor charge only in that Room does not print
2 The Total Labor charge I can not get to calculate.
I have tried =sum(nz(LaborChge,0) This gives me a number that adds the labor charge for each equipment item in the room group. There is only one labor charge for the Room.
The entire report is based on a query but when I put a sum in the query I get multiple record within the Area equal to the number of labor charges in the invoice. Can not successfully put the sum there.
I have tried several (hundreds maybe) other ways without success. I fell like Edison when he said “I have not failed but I have found 2000 ways it doesn’t work.”
Any help you can give on calculating the Total labor charge and figuring out why the Labor footer within the room won’t print if there was no equipment used in the job..
Anyone that could help would be saving my sanity. Thank you ahead
The INVOICE table has a 1 to many relationship to the EQUIPMENT and the LABOR table.
The EQUIPMENT table and the LABOR table are grouped by the ROOM in which the equipment is used and the labor is done.
Petty simple stuff, right!!! Wait
I have a report that looks like this
Report header (design view)
Company information
Room Group
txtArea (this is a field in the EQUIPMENT and in the LABOR tables)
Details
Oty description cost extended (fields from EQUIPMENT table)
GroupFooter
LaborDescription Charge (fields from the LABOR table)
Report Footer
Total equipment Cost (=sum(extended) (textbox name for extended cost)
Total Labor Cost =sum(charge)
Amount paid to date (field in payment table)
Balance Due =txtTotalEquip+txtLaborChge)-AmtoDate
The report should print something like this (print preview expected)
Company Info
Invoice #9999999
Room1
1 EquipA $$$$$ $$$$$
1 EquipB $$$$$ $$$$$
Labor $$$$$$
Room2
1 EquipA $$$$$ $$$$$
2 EquipB $$$$$ $$$$$
1 EquipC $$$$$ $$$$$
4 EquipDB $$$$$ $$$$$
Labor $$$$
Room3
Labor $$$$
Total of Equipment $$$$$
Total of Labor $$$$$$
Amount day to date $$$$$
Grand Total $$$$$$
Reasonable Yes!
Here is the problem.
1 The labor line for Room 3 with labor charge only in that Room does not print
2 The Total Labor charge I can not get to calculate.
I have tried =sum(nz(LaborChge,0) This gives me a number that adds the labor charge for each equipment item in the room group. There is only one labor charge for the Room.
The entire report is based on a query but when I put a sum in the query I get multiple record within the Area equal to the number of labor charges in the invoice. Can not successfully put the sum there.
I have tried several (hundreds maybe) other ways without success. I fell like Edison when he said “I have not failed but I have found 2000 ways it doesn’t work.”
Any help you can give on calculating the Total labor charge and figuring out why the Labor footer within the room won’t print if there was no equipment used in the job..
Anyone that could help would be saving my sanity. Thank you ahead
