#16
|
|||
|
|||
Quote:
Just need to work out for myself the best way of doing things. Thanks again. Rob |
#17
|
|||
|
|||
If you want to avoid Access I would propose that you post a Excel sheet with a reasonable quantity of data and (manually entered) examples of expected results.
Maybe it is not possible in Excel but let it depend on trial. |
#18
|
|||
|
|||
I have now been playing with pivot table for a week and have virtually got it exactly how i want it.
If only I had learned about PT's years ago!! One thing I am unable to do is to have a value field in between 2 Row fields. ie my columns are Venue - Capacity - Next Date - Note - and Max of Date 4 x Row Field and 1 Value Field The Max of date obviously returns the last date played at a particular gig. However, I want this column to be after the Capacity Column and the Next Date and Note to be at the end of the row like this Venue - Capacity - Max of Date - Next Date - Note 2 That is 2 x Row Field - 1 Value Field - 2 x Row Field Can this be achieved. Many thanks Rob |
Thread Tools | |
Display Modes | |
|
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 |