Summarising Query results

[newdba12345]

Hello everyone,


I have an Access 2013 database of soccer results with my own ratings for each game, for which I've created queries to select the records by the different ratings I've applied.

I can now get all the totals that I was after for the different types of ratings by running the queries, but I'm struggling to find an easy way to summarise the data in a form/chart/report etc.

All I need are the total number of records each query returns so I can do some very basic calculations to get the percentage they represent for each rating type, then have that display in a nice chart/report/whatever so I can see at a glance what's happening.

So for instance if I select all the top-rated teams that won, I'd want to divide that by the total number of records in the top-rated group to get a strike rate. Then I'd also want to summarise the results so I can see how many games finished 2-1 FT, 0-0 etc. as they are rated as well.

I've been struggling with this for a while and am not finding it easy using Access or Excel for some reason, to the point where I'm looking at using Microsoft Power BI instead.

However I'm not really happy having to use another piece of software as I'm trying to keep the system "standardised" so it only needs a copy of office to run on a PC.

Any ideas or advice greatly appreciated.

[ranman256]

make an append query and put your chosen results into a 'report' table.
build your chart to report on this table.