Darryl Collins
darryl at whittleconsulting.com.au
Thu Jul 25 20:43:32 CDT 2013
Hi All, Is it just me, a bug or something Access has always done? Whatever it is it is really starting to piss me off. Scenario: I have a whole stack of X-tab queries (100+ of the buggers) where I have the total quantity being x-tabbed as both a value (as the xtab part of the query) and also as a row heading so I can get a total per each row. And I want the damn total where it belongs (at least in my opinion) and that is on the LHS of the data. Why? Because this data gets exported to Excel where I always make my reports with totals on the Left and Top. Unlike the crazy fashion of the last 200 years of bottom and right, which is helpful to, ummmm... nobody. The Romans used the phrase "To Add Up" as even back then they knew the only sensible and logical place for the totals is at the Top where it is always visible. We still say "add up" but most folks these days "add down". Feh, Bah - humbug to that I say. Putting the totals top and left means: 1: they are always in the same cells - useful for consistency and audit and general sanity. 2: they are always visible at a glance and you don't have to hunt for them. 3: it make using those totals else-where in Excel simple, rather than it being a complicated exercise in vba or formulae to find them. Just to list a few good reason a normal and sane individual might like to do this. So why for the love of God does Access insist on 'automagically' (and randomly it seems) changing my queries to show the total on the RHS. I move the totals column back yet again to the far LHS of the query, save the query, run the query, and all is good - totals on LHS as saved. Should be 'end of story', but no.... Everytime I edit the damn query Access will reposition it again, which means I have open the query again, move it again, save it again. What a right Pain in Ar$e. Damnit MSoft. When I save the query in a certain layout, I want it like that. Not what some B grade coding Hack on a summer internship thinks I want. Grrrrrr!! Bugger off, when I save it - leave it alone! Very open to ideas and suggestions here folks as this one is really annoying me now.... Sheeesh, and they have just release SP2 for Office 2010. Darryl Collins Whittle Consulting Pty Ltd Suite 8, 660 Canterbury Rd Surrey Hills, VIC, 3127 p: +61 3 9898 3242 m: +61 418 381 548 f: +61 3 9898 1855 e: darryl at whittleconsulting.com.au<mailto:darryl at whittleconsulting.com.au> w: www.whittleconsulting.com.au<http://www.whittleconsulting.com.au/>