#Error Message?

[Mug1]

I'm attempting to "write" an inventory tracking system for a retail clothing boutique. However, my very simple "retail prices" report returns the #Error in the place where I should be getting a price. I told the program to do this: [wholesale price] * [multiplier]. Seems straightforward to me, but I'm not a computer program. How am I erring? Thanks.

 

[DougP]

When you mutiply numbers thay must be the same type.<br>You cannot multiply $4.00 * multiplier and get a number.<br>The four dollars needs to be 4.00 and so does the &quot;multiplier&quot;.<br>Make them both a &quot;double&quot; field type.<br>Also Try importing the &quot;wholesale price&quot; in first and make sure it is a number with no formating in place. Then do you multiplication second.<br>Or you could convert the &quot;wholesale price&quot; to a double with this function from Help<br>-------------------------------------<br>Dim MyCurr, MyDouble<br>MyCurr = CCur(234.456784) ' MyCurr is a Currency.<br>MyDouble = CDbl(MyCurr * 8.2 * 0.01) ' Convert result to a Double. <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[Mug1]

I thank you for your quick help. How could I have figured this out on my own? I couldn't find the error code listing and neither my manual nor the on-screen help were helpful. Is it merely a matter of knowing what to ask?