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 >
