All:
I have a report that lists quantities of stuff used over the course of
a year and it is grouped on each month. In the group footer I want to
insert the total for the month - easy stuff so far.
The part that has me stumped is that the units of use for each record
may not be the same (e.g., we may have one record at 5 lbs and one
with 4 kg). I've gone to some length in the forms for entering data
to prevent this, but I subscribe to the philosophy that nothing is
idiot proof - better idiots are unleashed very day. So what I want to
do is hide the totals if all the units aren't the same for the month
(since they would be meaningless). What is the best way to accomplish
this?
I've thought about running a query against the reports recordsource to
give me a count of the number of unique units - if I get more than 1,
I suppress the totals for all the months, but am not sure that is the
best approach.
For example:
I want totals in this case:
Jun 2007
Material 1 300 gal 3000 lbs
Material 2 200 gal 2500 lbs
Total 5500 lbs
I don't in this case:
Jun 2007
Material 1 300 gal 3000 lbs
Material 2 200 liter 250 kilograms
Any thoughts? Thanks
Tom