Excel or Access

hollies · #9 07-10-2017, 12:36 PM

Quote:

Originally Posted by gebobs

It's preferable to post an actual Excel sheet. You can do this by clicking Go Advanced.

At any rate, I have attached one that determines last date played for each venue using a pivot table. I added another date for Malmo to illustrate it. To do this, just get Max of Date.

Lots of ways to skin this cat though.

A few things:

* I had to change the date formats above to the silly American m/d/yyyy so don't let that confuse you.
* The day of the week data are somewhat superfluous as that can be shown in the Date field. Just choose the appropriate formatting.

Sorry, I am new to this depth with Excel. How do I go Advanced?

Thanks gebobs, that is exactly one of the things I am looking for. I have been playing around with it using filters etc.

We have played in over 260 different venues all with different names. However some of these are in different cities and, indeed, different countries. so, New Theatre, could be in Oxford, Blackpool or Sydney, Australia.

What I can't quite work out is how to get a report with three columns, venue, city, date (Last Played)

I have filtered out the countries I don't want, but I can't get past the City in a row above the venue and then a city total beneath that.

I have actually got rid of the subtotals but I want a 3 column answer rather than 2 rows. Is there a way to do this?

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel or Access for DB?	John H. Power	Word	3	08-03-2016 11:52 AM
Excel to Access to Excel for report automation	Nicholaspoe	Excel Programming	10	10-08-2013 08:13 PM
Access or Excel?	hektisk	Office	11	04-11-2011 04:24 PM
Should I uses Access or Excel?	tinkertron	Office	5	03-29-2009 08:30 PM
Excel or Access ?	inferno	Excel	0	10-03-2008 03:42 AM