Hi everybody,
I'm from Belgium and I have a question about queries.
Let me explain my situation.
I have a DB "clients" with for example...
client1 1
client1 7
client2 3
client1 1
client3 5
client3 1
client2 1
When I make a grouped report, I could have
client1 9
client2 4
client3 6
Now, "the" question... I want to have a query (not a report) that only gives me the results like the above report.
Can anyone help me, I have searched the help within Access, the internet but haven't found any solution. Can this be done?
Thanks!
I'm from Belgium and I have a question about queries.
Let me explain my situation.
I have a DB "clients" with for example...
client1 1
client1 7
client2 3
client1 1
client3 5
client3 1
client2 1
When I make a grouped report, I could have
client1 9
client2 4
client3 6
Now, "the" question... I want to have a query (not a report) that only gives me the results like the above report.
Can anyone help me, I have searched the help within Access, the internet but haven't found any solution. Can this be done?
Thanks!
Last edited: