I am having a big problem writing a query that will give the right answer to this problem.
Here’s my scenario, let say you have a house, and people are allow to go in and out of the house at anytime all year round, the only requirement is that their entry and exit date/time must be noted, and each person is given a unique ID on entry, but if a person leaves then come back he/she must still use the initial ID assigned.
Now, here’s my question; how do you use MS Access to query how many people occupy the house say in the whole month of January, April, June …, basically what’s the occupancy of the house within a given month, date range, time….
Thanks yall.
