Search results

Thank you again Banana. I have finally solved my problem. I made a silly mistake. To illistrate the root of the problem I have created a hypethetical structure for table A and table B that would cause this issue: Table A: CurrencyField . . . OtherField 1.7 . . . . . . . . . . 0 Table B...

Thank you for the quick reply. Union (without all) results in the same problem. The tables are distinct and the ALL is in there just as a matter of habit.

You could run a second query ontop of the first. Something like: Select A, B, [Sum of Blah] as Blah, C, D From [Sum of Blah query] I haven't found a way around listing all the field names out. A pain I know!

Hello all, I have an access query which I'm having trouble with. The query runs but the numbers that come out don't seem to make logical sense. The query (with query and field names substituted) is as follows: SELECT sum(currencyField) from A UNION ALL select sum(currencyField) from B...