Microsoft Office Forums Excel or Access

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #16  
Old 07-11-2017, 06:49 AM
hollies hollies is offline Excel or Access Windows 7 64bit Excel or Access Office 2016
Novice
Excel or Access
 
Join Date: Jun 2017
Location: Nottinghamshire
Posts: 22
hollies is on a distinguished road
Default

Quote:
Originally Posted by gebobs View Post
As far as I know, you can't get pivot tables to display like like that. You could filter the table but that's a pain in the arse.

Access can do it, fer sure. So long as you don't need to collaborate with anyone, then that would be the easiest way. Overkill, as Arvi said earlier.
Many thanks everyone for your help with this, I really appreciate it. I have learnt so much on both Excel and Access.



Just need to work out for myself the best way of doing things.

Thanks again.

Rob
Reply With Quote
  #17  
Old 07-11-2017, 08:09 AM
xor xor is offline Excel or Access Windows 10 Excel or Access Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,027
xor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of light
Default

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.
Reply With Quote
  #18  
Old 07-18-2017, 03:21 AM
hollies hollies is offline Excel or Access Windows 7 64bit Excel or Access Office 2016
Novice
Excel or Access
 
Join Date: Jun 2017
Location: Nottinghamshire
Posts: 22
hollies is on a distinguished road
Default

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
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel or Access 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
Excel or Access Access or Excel? hektisk Office 11 04-11-2011 04:24 PM
Excel or Access 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


All times are GMT -7. The time now is 05:26 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft