Help Tracking Data

  • Thread starter Thread starter David Carwile
  • Start date Start date
D

David Carwile

I have a question on how I should design part of my database in order
to keep statistics of changes over time. It is a way of showing the
performance of the database. I have a table which accepts records
that autonumber. I want to have it set up so in some way the database
will automatically track how many records are in the database on a
date, and I want to display this data in a chart. I'd like to make it
more complicated later, but I really just need help getting it
started. If you know what I'm tryin to accomplish, just send me a
brief outline of how I should do it. Thanks for any assistance.
 
Depending on how sophisticated you want to be, you can implement an
AuditTrail capability, such as outlined by Allen Browne at
http://members.iinet.net.au/~allenbrowne/AppAudit.html

For simpler needs, you could simply add a CreateDate field to your table,
and set its default value to Date (or to Now, if you want date and time).
Then, you could do a query to get the counts, grouped by CreateDate:

SELECT CreateDate, Count(*) FROM MyTable GROUP BY CreateDate
 
Back
Top