Help with totals query (2000/XP)

Topic

New Reply

Attached is an extract from a table on which I need to calculate some totals.

The table has two fields, LocationCode and Type. All I need is the percentage of each Type at each location. I assume what I need to do is simple but my mind has gone blank . Any pointers gratefully appreciated.

Reply | Quote

Replies

Just want to make sure that I understand what you want to do.

You want to derive a percentage of the number of times that [Type] grouped by [LocationCode] is of the total count of LacationCodes.

Reply | Quote

Just want to make sure that I understand what you want to do.

You want to derive a percentage of the number of times that [Type] grouped by [LocationCode] is of the total count of LacationCodes.

Reply | Quote

You can use a crosstab query to calculate the counts, and another query based on the crosstab query to calculate the percentages. See attachment.

Reply | Quote

Thanks, that’s exactly what I was after. I was trying to do it all at once instead of as two queries, so I wasn’t getting anywhere.

Reply | Quote

Thanks, that’s exactly what I was after. I was trying to do it all at once instead of as two queries, so I wasn’t getting anywhere.

Reply | Quote

You can use a crosstab query to calculate the counts, and another query based on the crosstab query to calculate the percentages. See attachment.

Reply | Quote