Currency in query 2

[beansmom]

I have looked through previous threads, but can't find an answer to my problem. I have a query with a currency field and a datediff calculted field resulting in a number of days. I need to create a new calculated field that shows currency\days. For example, $32,000\364 days. My query gives me a result of $87.00. It appears to be rounding. I need it to show $87.91. Thanks for any help.

 

[SkipVought]

Hi,

Try
[tt]
32,000[red]/[/red]364 days
[/tt]


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[beansmom]

Duh!!! My only question is why didn't I get an error, instead of a whole number?

 

[traingamer]

See arithmetic operators:

\ Operator

Used to divide two numbers and return an integer result.

/ Operator

Used to divide two numbers and return a floating-point result.

Greg
People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard