thanks both worked..probably using temp tables was the idea.

There is one more thing

In my other form's query I have

select (col1/col2) as Amt from Trades group by Month

now if col2 has...

I tried writing the 2nd select statememt 1st and then the 1st select statement but i get an error like 'ambiguous column name 'theMonth'.

I did this because for a particular...

Thanks for replying

but the @Month is not passed to the query, only the @CustId is passed.

So in that case I tried giving group by month in

Set @CustMonthOrders = (Select...

Thanks its working in sql but what if I change to a access database. COALESCE doesn't seem to work in access.