If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Double entries in a query
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. |
#2
|
|||
|
|||
On Mon, 29 Nov 2004 09:05:02 -0800, J-E
wrote: 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. 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Financial Comparison | Steven Cheng | Setting Up & Running Reports | 13 | November 26th, 2004 10:59 PM |
Unmatched Query Mess | Natalia | Running & Setting Up Queries | 8 | October 28th, 2004 02:36 PM |
Return repeats info in "8s" | Joy Rose | Running & Setting Up Queries | 14 | October 13th, 2004 10:07 PM |
Too Few Parameters error Mail Merge Access Parameter Query | Tony_VBACoder | Mailmerge | 3 | September 14th, 2004 12:15 PM |
Taher | Setting Up & Running Reports | 1 | August 31st, 2004 09:07 PM |