I have used an aggregate function to count the total number of entries for each pupil in a table. I then wish to use that total filed in another query but when I join the queries together I am not able to edit any of the fields in the original query. How can I show this total and still edit data. I also tried a manual update of the data to a field in the table but it will not let me do that either.
Any help appreciated.