Posted by Rico on 11/23/06 15:47

Forgot to respond. Thanks! That did the trick!

"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
>>
>>
>>
>
>

• Next in forum: Re: Help with a complex UPDATE query
• Prev in forum: Re: appending two datetimes which were converted from strings
• Thread view: Re: 3 / 2=1? Strange result in expression...HELP!

[Reply to this message]