Double entries in a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My query is giving the clients that have log in the website. Some clients are
logging in more than once in a single day, and I just want to know if the
person log in once or more. I dont whant to know if he log in more thant
once. So how can I show once a client who came more than once.
 
My query is giving the clients that have log in the website. Some clients are
logging in more than once in a single day, and I just want to know if the
person log in once or more. I dont whant to know if he log in more thant
once. So how can I show once a client who came more than once.
Click to expand...

Create a Totals query (click the Greek Sigma icon, looks like a
sideways W); group by client and count logins.

Since you don't describe your table structure it's hard to be more
specific than that!

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top