That would be Great! here it is
The main report has all the heading information, ie customer name
address etc and Invoice number.
Three subforms:
One has equipment charges for that invoice
One has labor charges for that invoice.
The last has the totals for the invoice
There are times when the invoice has only equipment charges and no
labor chagre. This prints ok.
There are times when the invoice has labor charges and no equipment
charges. The labor charge information will not print and the totals
subform returns error,
When the invoice has both labor and equipment charges the invoice is
beautiful.
Orginally, the equipment charges data was in the query with the invoice
header. After your first post I now I have created a query and a
subform for equipment and a query and subform for labor. Both subforms
are linked to header information through the header query containing
the invoice number parameter that the report is built on. The header
query has the invoice number.
The header, labor and equipment data are stored in tables with one to
many relationships. Header is the one and labor and equipment are the
many. Labor and Equipment have no direct relationship.
Hope this makes sence. Any help would be appreciated.
thanks
Maureen
PS Is there a great functionality difference in using subforms on a
report rather than subreports?
