Anyone ever see this displayed in a calcuated field.
I have a cell that is populated by 1 of 6 rules based on another cell.
Example
Cell 1 Cell 2
If Cell 1 Btwn 1 -10 Cell 2 Value is .05
If Cell 1 Btwn 11-20 Cell 2 Value is .10
If Cell 1 Btwn 21-30 Cell 2 Value is .15
A basic percentag discount thing...
For some reason the .05 (5%) always throws the 1.#QNAN value after the data
has been saved (Access 2003) and re-displayed in the form.
All the other rules work fine..
Anyone ever seen this 1.#QNAN value, and where it comes from
TIA.
Jay
Just noticed one other thing...
The problem seems to be when I do the following calculation.
(1.00 - @DiscountValue) * (@UnitPrice * @Quantity)
The only discount value to throw the odd text error is .05 (or 5%)
All others work fine...
> Anyone ever see this displayed in a calcuated field.
> I have a cell that is populated by 1 of 6 rules based on another cell.
[quoted text clipped - 15 lines]
> TIA.
> Jay
Paul Webster - 20 Nov 2005 15:57 GMT
> Just noticed one other thing...
> The problem seems to be when I do the following calculation.
[quoted text clipped - 22 lines]
>>TIA.
>>Jay
Does this help?
http://www.adminlife.com/247reference/msgs/6/30095.aspx
JESwan - 21 Nov 2005 15:52 GMT
Right on topic.. Thanks...
I'll take a look...
> > Just noticed one other thing...
> > The problem seems to be when I do the following calculation.
[quoted text clipped - 25 lines]
> Does this help?
> http://www.adminlife.com/247reference/msgs/6/30095.aspx