I am getting an error message from a simple calculation.
The formula is performance * utilization. Both numbers are a percentage if that has anything to do with it. 72% times 76% is 57%. But instead I get #ERROR
getting #error message from query and I don't know why
Competent Performer
Windows 7 64bit 
Access 2010 32bit
I am getting an error message from a simple calculation.
The formula is performance * utilization. Both numbers are a percentage if that has anything to do with it. 72% times 76% is 57%. But instead I get #ERROR
Who is John Galt?
Windows XP Access 2007
They are left aligned, thus seen as text values. I'd change that at the source, but you can work around it by surrounding each in the CDbl() function.
Competent Performer
Windows 7 64bit Access 2010 32bit
Thanks, that did it!
Who is John Galt?
Windows XP Access 2007
simple query returning query is to complex error message
Error 2759 - Text Box linked to a combo box query returns error message when I sort on a split form
Replace VB Run-time Error Message with Custom message
Posting Permissions
Reply With Quote