If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Im getting a #Num! in my text box
Hello, I have a text box and its function is only to give me a % from two
other text boxes. I used =[Text25]/[Text89]&"%" when I go to regular view its giving me a #Num! in the text box. The other two text boxes have time in them and show 0:00 what am I doing wrong? This is my first database so please explain for a newb! Thanks!!! |
#2
|
|||
|
|||
Im getting a #Num! in my text box
You need to understand just a little bit about math. Apparently you are
attempting to divide by zero. I'm not sure why you would want to divide one time by another but the general way of handling this is: =IIf(NumberA = 0, 0, NumberB/NumberA) -- Duane Hookom MS Access MVP -- "oxicottin" wrote in message ... Hello, I have a text box and its function is only to give me a % from two other text boxes. I used =[Text25]/[Text89]&"%" when I go to regular view its giving me a #Num! in the text box. The other two text boxes have time in them and show 0:00 what am I doing wrong? This is my first database so please explain for a newb! Thanks!!! |
#3
|
|||
|
|||
Im getting a #Num! in my text box
That works well, but I use a little different approach.
=NumberB / IIf(Nz(NumberA,0) = 0, 1, NumberA) Which way you do it depents on the result you want. Yours will return a zero, mine will return Number B. "Duane Hookom" wrote: You need to understand just a little bit about math. Apparently you are attempting to divide by zero. I'm not sure why you would want to divide one time by another but the general way of handling this is: =IIf(NumberA = 0, 0, NumberB/NumberA) -- Duane Hookom MS Access MVP -- "oxicottin" wrote in message ... Hello, I have a text box and its function is only to give me a % from two other text boxes. I used =[Text25]/[Text89]&"%" when I go to regular view its giving me a #Num! in the text box. The other two text boxes have time in them and show 0:00 what am I doing wrong? This is my first database so please explain for a newb! Thanks!!! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Linking text boxes | Volunteer Mom | Publisher | 7 | November 12th, 2008 01:29 AM |
Ideas On Producing Envelopes & Labels For Data | RNUSZ@OKDPS | Setting Up & Running Reports | 0 | April 28th, 2005 03:22 PM |
Help with design | Ronnie | Database Design | 6 | March 12th, 2005 02:53 PM |
Access reports with a horizontal line after each record??? | Bill via AccessMonster.com | Setting Up & Running Reports | 6 | March 9th, 2005 04:51 PM |
Outline | Renee Hendershott | Page Layout | 2 | December 25th, 2004 02:49 PM |