Error in equation

  • Thread starter Thread starter L R Fizia
  • Start date Start date
L

L R Fizia

In a table I have 4 fields (amongst others) called Gauge, Width, Index & SG

In forms & reports (but not in every one) if I do Gauge * Width * Index *
SG, I get the wrong answer SOMETIMES, but the mistake repeats every time

If I then print out alongside the equation, each variable, they are correct.

After a bit of time amending equations., I have found that the problem is
with the Field 'Width' - Is this a reserved word? - Back in the original
query I added a field w:=[Width]
The equations work fine with W instead of Width]!
 
Try using brackets around the field names
[Gauge] * [Width] * [Index] * [SG]

Width is definitely a reserved word as is Index

You can check for reserved words at Allen Browne's site
http://allenbrowne.com/AppIssueBadWord.html

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
 
Back
Top