alzdba,

Thanks for the heads up. I've changed the union to a union all. Thanks again!

Alzdba, the problem wasn't trying to get the query to run faster, but to get it to return the correct information. I was having a bear of a time...

jpipes,

Thanks for your help, I'm getting an error on the statement:

Incorrect syntax near the keyword 'GROUP'.

It appears that it is choking on the group last group by portion on...

What the problem is, is that I need to get a sum of all transactions for a month, on a per month basis. Tables are basically:

table1:

docamnt,date

12.37, 1/12/2003

25.01 1/15/2003

11.45,...

greg,

thanks for the help. that got me headed in the right direction.... I think this query will work for me, although it's a bit shorter of a time span.

select...

Greg,

Thanks for the help. that doesn't seem to work... from looking at the sql, it would seem that your example relies on the field having the same date as...