|
Posted by MC on 10/29/06 18:04
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]
|