Just wanting to pick the collective brain of the forum and ask how I would be best off doing this...
I maintain a large database of employees. Each employee has a record (stored in "user" table) and any changes relating to any of their employment details are audited by recording a record under the "user_change" table.
I send weekly audit reports out to a number of system administrators and currently, I have about 15 separate queries set up.
Each of these queries has to be run once a week and the number of records returned from that query entered manually into a spreadsheet field. For example, how many members of staff changed their name this week. How many members of staff started employment this week, and so on.
I'm trying to make life easier for myself. What would be the best way to do this? Is there a way I can set up a single query with multiple "counts"? Or maybe a form which I can just load, key in some dates, and then display the relevant data?
Would I still need 15+ separate queries set up and stored as objects, or would I be able to incorporate it all into the one query / form?
Just looking for some advice on how others would do this sort of thing... the result I end up with is always simply a number. It's just figures I need, nothing complicated.
I maintain a large database of employees. Each employee has a record (stored in "user" table) and any changes relating to any of their employment details are audited by recording a record under the "user_change" table.
I send weekly audit reports out to a number of system administrators and currently, I have about 15 separate queries set up.
Each of these queries has to be run once a week and the number of records returned from that query entered manually into a spreadsheet field. For example, how many members of staff changed their name this week. How many members of staff started employment this week, and so on.
I'm trying to make life easier for myself. What would be the best way to do this? Is there a way I can set up a single query with multiple "counts"? Or maybe a form which I can just load, key in some dates, and then display the relevant data?
Would I still need 15+ separate queries set up and stored as objects, or would I be able to incorporate it all into the one query / form?
Just looking for some advice on how others would do this sort of thing... the result I end up with is always simply a number. It's just figures I need, nothing complicated.