Hi - I have created a query that sums the number of times different selections are made from a dropdown box in a form, this accumulates over the course of a year. I was wondering if its possible to display this value in the form as a live running total. So that when other users make a selection the change in total will appear (I could then reset this at the end of the day), so it would be a like a counter of those events (or even if its once at the beginning or end of the day). I have used task scheduler to email the morning and afternoon totals to users, but was wondering if its possible to have something visible in the database.
Is something like this available in Access?
Thanks for any ideas or pointers as to how I could start this
Is something like this available in Access?
Thanks for any ideas or pointers as to how I could start this