Hi everyone,
I used to be a member of this forum a few years ago and haven't had to create any databases in quite some time. I can't remember my old login so I created a new one. In any event I'm hoping I can get some help with a problem I'm having with a new database I'm working on.
I have a report that uses a query to count the number of sign-in's we get from students at our tech center. On the main report the information is supposed break down the demographics of the students by gender, languages spoken, etc. The sub-report evaluates the number of sign-in's received by the day of the week and hour of the day. The two parts of the report run off of different queries that come from the same table.
The table logs a username, an id, a sign-in date, sign-in time, and a unique id assigned to that sign-in. The query is supposed to filter this data by date. The problem I'm having with the query for the main report is that it's counting the total number of sign-ins. For the life of me I cannot figure out how to get it to only count a user once, no matter how many times they've signed in. Can someone help me figure out how to eliminate the duplicate sign-ins and only get it to show me 1 sign-in from a user during those given dates? Thanks in advance everyone!
I used to be a member of this forum a few years ago and haven't had to create any databases in quite some time. I can't remember my old login so I created a new one. In any event I'm hoping I can get some help with a problem I'm having with a new database I'm working on.
I have a report that uses a query to count the number of sign-in's we get from students at our tech center. On the main report the information is supposed break down the demographics of the students by gender, languages spoken, etc. The sub-report evaluates the number of sign-in's received by the day of the week and hour of the day. The two parts of the report run off of different queries that come from the same table.
The table logs a username, an id, a sign-in date, sign-in time, and a unique id assigned to that sign-in. The query is supposed to filter this data by date. The problem I'm having with the query for the main report is that it's counting the total number of sign-ins. For the life of me I cannot figure out how to get it to only count a user once, no matter how many times they've signed in. Can someone help me figure out how to eliminate the duplicate sign-ins and only get it to show me 1 sign-in from a user during those given dates? Thanks in advance everyone!