Thread: Excel or Access
View Single Post
 
Old 06-23-2017, 01:25 AM
hollies hollies is offline Windows 7 64bit Office 2016
Novice
 
Join Date: Jun 2017
Location: Nottinghamshire
Posts: 25
hollies is on a distinguished road
Default Excel or Access

Hello

My question is can I achieve what i want to using Excel or would I have to use Access.

I follow a music band who have toured for many years and I would like to record and analyse every venue they have played at, the dates, the amount of seats sold, costs, profit etc.

So, over the last 10 years, we may have played in one particular venue, 6 times.

I want to be able to find out how many times we have been there, the dates, the sales records etc and the cumulative number of seats sold at that venue over the period.

Many thanks, Rob
Reply With Quote