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
