Repeated Queries and updated data

[jppevy]

I am running repeated calculation queries of different data, but its is not working to well. I can give a simplified example:


I have one query listing the total number of hats made from wool. I then have a second query of that lists the total number of hats made from wool and are black. I have third query that calculates the percentage. I have many different hats of many different colors, and i am doing the same three queries over and over. However, the calculated field for percentages does not update. E.G. I have 100 wool hats, 10 wool,black hats, 10%. The next round: i have 100 wool hats, 5 wool green hats, its will still show me 10%, as its is still calculating based on the previous data.

I am sure its something simple, but how can i go about this most efficiently and why is not updating?

Thanks a lot !

[June7]

Would have to examine data and calculations. If you want to provide db, follow instructions at bottom of my post.