Help with Calculation on a Report

  • Thread starter Thread starter dawn.pitzer
  • Start date Start date
D

dawn.pitzer

I am trying to Calculate a % on a Report in Access 2003 with the following
formula:
= [SumOfPSI UNTS] / [SumOfTOTAL UNTS] but I get a type mismatch error.

What am I doing wrong. Can you help me write a correct formula?

Thanks,
 
A type mismatch means you have something identified in your table as one
datatype and are trying to manipulate it as another datatype. In other words,
you may have the datatype of a field set to date/time and you are trying add
it. Or you may have a text datatype defined and you are trying to insert or
manipulate dates. So, probably either PSI or toal units is not identified as
a number.
 
If the two controls are in different sections of the report (e.g. one is in
the detail section and another is in the footer section), you may encounter
this problem as well.

--------------------------------------------

HTH

Don''t forget to rate the post if it was helpful!

Please reply to newsgroup only, so that others may benefit as well.
 
Back
Top