calculating with money * number or decimal format

[ifntech]

I have two fields I want to calculate in ASP page and I get a type mismatch. The calculation is 20% * $10,000.00
I used money format and tried both decimal and numeric for the % number at .2.

Keep getting type mismatch when I try to calculate in the the ASP form.

 

[dbomrrsm]

what data format are the figures held as in the db

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[SQLSister]

I use money and decimal in the same calculation all the time without having a problem. Let's see your SQL code.

Questions about posting. See faq183-874
Click here to learn Ways to help with Tsunami Relief