- Messages
- 11
- Reaction score
- 2
- Points
- 3
junaidj Firstly import all the csv files to a datbase.
Then create a query using Region from your Venue regions table and Band from December Bookings table.
In the Access toolbar, there is something known as TOTALS.Click on it.
Instantly, a new thing called Totals drop down sort of thing pops up above the Criteria row in the query.
So in that list, for Bands select Count.
Save the Query.
Now you have two alternative ways to make the chart. Export the chart to an Excel workbook and create a chart in Excel or create a chart in Access itself.
thanks bro