Um. Never mind. I read the mail in the wrong order. Thanks Dennis. On Mon, Oct 27, 2008 at 1:50 PM, Bill Downall < [EMAIL PROTECTED]> wrote:
> Jan, > Please post the query that does the calculation. It almost certainly has to > do with an integer in the same position in the first query of your compound > union select query. > > On Mon, Oct 27, 2008 at 9:48 AM, Jan Barley <[EMAIL PROTECTED]>wrote: > >> Hey y'all! >> Can't believe I'm still wearing out this old horse, but here goes!!! I >> have been able to successfully create a 3 part union select view which sums >> up invoice totals, payment totals, and cancellation totals by month. What I >> don't understand is why when all three calculations are based on a currency >> field, then why do the union selects create an integer (I think) field? >> Here's what I get: >> >> DMonth TIAmt TPAmt TCAmt >> 200701 $1452.00 1250 250 >> 200701 $2490.75 1590 100 >> >> etc. >> >> Guess this wouldn't be a big problem except it seems to be off a dollar or >> two and when you're dealing with accountants, it is a big deal!!! Any >> suggestions? Thanks so much! >> >> Jan Barley >> > >
