Renehubard,
Sorry but no I don't know of any other software that I would put in the same league as Access (and with Pivot tables).
I can't believe this whole thing. The pivot charts and tables in Access were far superior to the excel ones for the function I have been using them for many years. the majority of the databases I have written over the past decade have heavily relied on the
pivot table/chart views. I am now writing a little accounts database for my new self employed venture and realise I can't write something as simple as a P&L or balance sheet query that works without dumping it into excel. Who in their right minds thinks that
is a workable solution. Why did I bother learning how to manipulate access if you're going to make it so that I have to pretend excel is a database even though it patently isn't? Nor can I display large amounts of manufacturing run time trend data or cpk data
as neatly or as efficiently as I used to. Again, I will have dump vast amounts of data out of current access dbs into excel so I can view charts and historical reports I have been used to using regularly and I fear excel will simply fall over. that and it
is a nonsense to use two programs when one was previously enough. It is also stupid to have to have dozens of spreadsheets flapping about than having all data and reporting sitting neatly in one spot. I can add my voice to those that have stumbled upon this
thread in a vain hope to see where the most useful functions of Access have gone that are utterly exasperated at the frankly flippant responses coming from MS. if we apply the same logic to other programs then you shouldn't be able to put pictures of any kind
into Word because it's for writing and there's better software for pictures. Use Paint or Publisher or Powerpoint or ... oh, hang on.
totally flabbergasted
Maybe it's time to see if Apple have caught up yet. Maybe I should just try and forget all of the developing I've taught myself and spend my time considering how fluffy kittens are instead? Let someone else fiddle about with those pesky numbers. In fact
it would be easier and just as effective now to go back to paper and pencil and adding up by hand. Just lob a load of labour at it and it'll all be ok. Actually, why stop there, go back to working it all out on blackboards and then wait for someone to carve the
answers into a clay slab that can be glazed and fired for future generations to marvel at how wonderful we all are.
Sorry - I may have gone off point a little there
ciao