|
Posted by Rico on 10/29/06 19:43
That did the trick. Thanks MC. I thought it had something to do with the
data types, but being a newbie didn't think about "Decimal".
Thanks again!
Rick
"MC" <marko_culoNOSPAM@yahoo.com> wrote in message
news:ei2qf1$a13$1@ss408.t-com.hr...
> Try converting one of the values to decimal. For example:
> select 3/2 results in 1 BUT
> select 3/2. should result in 1.5
>
> Difference is in datatypes...
>
> MC
>
>
> "Rico" <you@me.com> wrote in message news:BP51h.34135$P7.18677@edtnps90...
>> Hi Folks!
>>
>> I have a strange thing happening; I have a field that Counts the number
>> of
>> records and another field that shows the number of clients
>> (Count(RecordID)=3 and NoOfClients=2) When I do a simple expression
>> "Count(RecordID)/NoOfClients" the expected result should be 1.5. Instead
>> the result I get is 1. Any ideas?
>>
>> Thanks!
>> Rick
>>
>>
>>
>
>
Navigation:
[Reply to this message]
|