By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,116 Members | 1,097 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,116 IT Pros & Developers. It's quick & easy.

How to count specific records and put them in a separate table

MrKorrel
P: 2
I am uploading an issue log weekly into access. It's a list of numbered tickets from which I can derive which tickets are planned to go into our production system and when (which week of the year) and which tickets got closed and when (in a specifc week of the year).
On my reports I can do a DCOUNT to have a count of "planned" and "closed" tickets per week(number).

I really want to do that count on the original table and put the results in a separate table and work from there.

So far I was not lucky doing so using the count function in queries. Anybody has some tips?

Thanks,

MrKorrel
May 10 '07 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
The basic rule is you don't store calculated values in the tables. It's too difficult to monitor data integrity. Calculated values should only be calculated as and when required.

Mary
May 12 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.