Advanced Beginner
Windows Vista 
Access 2007
I have a imbalance text box that finds the percent difference between the two amps. If MaxAmps is 0 nothing will display. The control source is : =IIf([MaxAmps]=0," ",(([MaxAmps]-[MinAmps])/[MaxAmps])) , this works perfectly fine but I have found one case where it does not and that is when there is a MaxAmps value but MinAmps=0. I am confused why this does not work even though it is just subtracting 0. Any suggestions will be greatly appreciated!
Access Developer
Windows XP Access 2003
Hi
In the one case where it does not work, what is the value of MaxAmps and what is the result please.
If this helped, please click the star at the bottom left of this posting and add to my reputation. Many thanks.
Bob Fitzpatrick
Advanced Beginner
Windows Vista Access 2007
I just didnt have a big enough width for 100.0%, woops
Access Developer
Windows XP Access 2003
Easy mistake to make
If this helped, please click the star at the bottom left of this posting and add to my reputation
Bob Fitzpatrick
Subform -> Parent form requery not working correctly
Search field is not working correctly
Posting Permissions
Reply With Quote