Deep Software

[sclaywell]

I have been struggling with what I would have thought was a simple query. I'm looking to get a count of the number of unique visitors per day. I have been having no luck with this, I have tried to create a subquery to get the distinct users from the Visit table and then a count of those users for each day against the Date_Time table. When I attempt to run the query in access, I am prompted for the Date_Time as a parameter. Any help with what I may be doing wrong would be welcomed!

Here is the query that I tried to create:


Select Count(userName) As [Number of Visit], Date_Time.Date,userName
From visit, Date_Time
where visit.BegDateTimeID=Date_Time.ID
and exists (select distinct userName
From Visit;)
Group by Date_Time.Date,userName
Order by Date_Time.Date,userName;