You Can't Calculate Totals on that!...SO #@!%#! WHAT, YOU GREAT PILE OF !@#
726749Oct 13 2009 — edited Oct 14 2009In Access you have an asterix which represents every field in the table. Useful if you want to see all the data in a table for a single record. I've done it a million times before.
So why is it telling me that I can't calculate totals on the *, so I should remove it from the query grid and replace it with the fields I want and calculate totals then.
I DON'T WANT TO CALCULATE ANY #!@%#@!! TOTALS!!
I AM PUTTING THE FIELDS I #@!%$#! WANT - I WANT ALL OF THEM!! I JUST DON'T WANT TO DOUBLE CLICK 30 TIMES WHEN ONCE WILL DO!
It's driving me insane because I'm going through hundreds of Oracle tables and it takes so long to browse to the record I'm looking for and it should work to use the asterix, I've done it so many times before.
How do I override this utterly unhelpful behaviour? Am I stuck in some sort of "Queries will only calculate Totals! mode that I don't know about?
I know, I know, Access is a micro$loth invention, not Oracle, but we have to use an ODBC link to the SQL database via Acces and it's going to kill me.
Unless I slam my PC into my neighbour's head first!
Any help greatly apprciated.
Sorry for the rant!
Cheers
IsNull