J
Joe Bohen
I have a report, which is based on a query on two tables,
(example1) one table contains invoice line details, and
the other contains the collective total for the whole
invoice. I wish to see both detail lines if they exist
but only one figure for the invoice total (example2). Is
it possible by referencing the record count property to
leave blank the invoice total where there is more than one
detail line? There is no line cost available.
Example1:
Invnumber Detail Total
001 1 widget 10.00
002 2 widgets 20.00
003 1widget 10.00
003 1widget nut 10.00
Report Total 50.00
Example2:
Invnumber Detail Total
001 1 widget 10.00
002 2 widgets 20.00
003 1widget 10.00
003 1widget nut
Report Total 40.00
(example1) one table contains invoice line details, and
the other contains the collective total for the whole
invoice. I wish to see both detail lines if they exist
but only one figure for the invoice total (example2). Is
it possible by referencing the record count property to
leave blank the invoice total where there is more than one
detail line? There is no line cost available.
Example1:
Invnumber Detail Total
001 1 widget 10.00
002 2 widgets 20.00
003 1widget 10.00
003 1widget nut 10.00
Report Total 50.00
Example2:
Invnumber Detail Total
001 1 widget 10.00
002 2 widgets 20.00
003 1widget 10.00
003 1widget nut
Report Total 40.00