S
Sheila D
Hi
I have a report identifying information about stands sold at an exhibitionm
and doing numerous calculations based on the principle 1 stand, 1 invoice
number. Occasionally additional space will be sold and a 2nd invoice raised
to cover extra but quoting same stand number.
I know I can count the unique stand numbers by grouping on Stand Number and
counting overall BUT I need the report to be sorted 1st on Customer Name and
can only get the correct answer if sorted 1st on Stand number.
I can't do the count in underlying query as whole principle of database was
1 invoice 1 stand - 12 months down the line this is apparently no longer the
case!
ANy help much appreciated
Sheila
I have a report identifying information about stands sold at an exhibitionm
and doing numerous calculations based on the principle 1 stand, 1 invoice
number. Occasionally additional space will be sold and a 2nd invoice raised
to cover extra but quoting same stand number.
I know I can count the unique stand numbers by grouping on Stand Number and
counting overall BUT I need the report to be sorted 1st on Customer Name and
can only get the correct answer if sorted 1st on Stand number.
I can't do the count in underlying query as whole principle of database was
1 invoice 1 stand - 12 months down the line this is apparently no longer the
case!
ANy help much appreciated
Sheila