Query Issues

[Jimruns919]

I have 2 tables. One is the BadgesAudit and the other is the BadgesList.

I created a query that goes through the BadgesAudit and counts how many times a badge shows up on the list. This works fine. When I tried to join the query with the table and have it update its numbers, I receive an error stating I need to use an updateable query. I do not know why that is happening.



Well I decided to instead use a Make-Table query and it creates the table correctly but when I create the update query between the two tables, all it does is put a 1 in the BadgeCount field instead of the correct count. I cannot figure this out. For example, BadgeCount has badge 1 as 86 but the badgeCount in the badge list is only 1 not the actual number.

Any help would be appreciated.

[Welshgasman]

And you cannot possibly shows us the queries sql that you used?

[xps35]

The count is a calculated value and you should not store that. Just calculate it whenever needed.

[Micron]

Why your query can be read only:
http://allenbrowne.com/ser-61.html

I would guess that your issue is the very first one in the list. Also agree - you should not store calculations - just do them on the fly in a form or a report.