Been there, done that, Bill. BTW, chances are, you are the one that clued me into this trick many, many years ago.
Dennis ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Downall Sent: Monday, October 27, 2008 12:53 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Union Select 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]<mailto:[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]<mailto:[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
