Show total of query results with percentage

[the-m0th]

hi everyone,

I've just made this query at work, it brings up the results from a database of telephone surveys. sorry about going all gestapo on the table names and codes, I'm unsure as to how told off I could get for placing identifiable images on the internet



basically I would like to extend this query so it shows the sum of the "CountOfQ1 22" column and also shows what percentage of that total each entry in the "Q1 22" column is.

This will enable me to have results for the day sent to me at home every night at close of business as the person supervising the call centre at the time can run the query and email me the results.

thanks for taking the time to read this and thanks in advance for any assistance given

Wayne

 

[Ranman256]

make a query Q1 that counts all records, qsTotal

make a count query Q2 that sums each item ,qsCountEach and add in Q1 into this query but DO NOT LINK THE TABLES. Let each stand alone and bring down the Total field from Q1.
Now you can make the %.

 

[the-m0th]

hi, thanks for taking the time to reply. I'm struggling to understand what you mean.

the database only contains one table, 'Q1 22' is a field within the table that has a letter placed into it depending on the response to a question. I have another query that just does a total count between 2 dates and times and then I have this one that counts each response within the field between 2 dates and times. I'd like to sort of combine these 2 queries and have it work out what percentage of the total each response has.

edit:- I should also add that not all records in that field are filled, it contains blank records for people who have not been surveyed yet.

Thanks again

Wayne

 

[apr pillai]

Check this out: Percentage on Total Query

 

[the-m0th]

cheers mate, i'll have a good look through that tonight.