getting subject error in one of the access query. any idea...

Thanks in advnce...

Rupen Anjaria.:)
------------------
We CAN'T avoid problems, but can solve it.

I am not sure what this means. Can you post the sql and what the data should look like, and what the data looks like when it is truncated?



mmcdonal

Thanks for the reply!!!
Query - "Select sum(lct)/sum(amt) from table1"
data should be in real number with 2 to 4 digit of decimal,
it dosen't shows any data it gives this error and terminates.

I guess it gives around 12 to 15 digit after decimal point and hence creates problem.

Rupen Anjaria.:)
------------------
We CAN'T avoid problems, but can solve it.

Coud it be the missing parens? Did you create this in desinger, or did you write the SQL?

"Select sum(lct)/sum(amt) from table1"

Should be

"Select sum((lct)/sum(amt)) from table1"



mmcdonal

i created it, but this seems working..

"Select CDbl(sum(lct)/sum(amt)) from table1 where prod = 'xx'"

but returns nothing if i remove product clouse and use group by as..

"Select CDbl(sum(lct)/sum(amt)) from table1 Group by prod" Any idea..?

Thanks again..

Rupen Anjaria.:)
------------------
It is not difficult to be on TOP...It is difficult when you carry Truth,Commitment and Transparency with you.

How about:

SELECT table1.prod, CDbl(sum(lct)/sum(amt)) As Something
FROM table1
WHERE table1.prod = 'xx'



mmcdonal

  Try using something like;

rst!AvgPurPrice = CDbl(Round(AvgPrice, 2))

If you use Sql Server as BE, I advice you to use float data type for the field.

Ashfaque