Thursday, October 2, 2008
AAARRRRAAAGGGGHHHHH!
I just spent two &^@&!&@ hours fighting with PivotTables in Excel trying to group my data by year and having Excel tell me to piss off.
Why on earth do you have to copy data between Access and Excel and paste it as text only if you want to format dates as tables? Once I brought the damned date column into Excel I couldn’t do a THING with it to change the formatting.
I hate Access.