Hi All,
I'm reletivley new to Access and am working on a project with a User database. Also a first time poster here, so please bear with me!
I have a database with a large table named tblUsers. All users, active and inactive are located here. While I realize this is not an ideal set-up, it's not feasible to change as there is already a large amount of other forms and tables and queries taht utilize this current setup.
I need to find a way to specify a date range and have Access come back with the number of active users for each date in the date range specified.
I've not been able to come up with a solution. So far I've created a query that lists all of the active users for a specified date (singluar) and then the report counts them to give me the result. I've not been able to expand this to the range concept. I initially thought that I could maybe even create a macro that would rerun the query for each date in a specified range and then find some way to store/tabulate the data as it went, but was unable - my knowledge is somewhat limited.
Any pointers at all would be very helpful!
Chris