Show us the command to create the union? ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Jan Barley Sent: Monday, October 27, 2008 8:48 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Union Select
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
