Am trying to create a calculated field in a query based on one table and one query. The table lists each client and their number of seats at each location, the query sums the total number of seats at each location. I want the calculated field (in a new query) to divide each client's seats at each location by the total seats at that location. Each location is defined by a 3 digit code in its own field in both the table and the query (the query is just a sum of the seats column in the data table grouped by location). Hope this makes sense.



Pretty sure there is a simple way to do this, just cant seem to get it to work.



Thanks in advance...