Find duplicates query

[rscosta]

Hi

I already search several past threads about this subject, but couldn't find
what I'm looking for. Hope you can help me. Here it goes:

I've build a query to extract all the client meetings within a period. This
query is working great and it does exactly what I want. Let me give you an
example:

Meetings summary

record 1 - Date1 - client 1
record 2 - Date 2 - client 2
record 3 - Date 3 - client 1 (again)
record 4 - Date 4 - client 3
record 5 - Date 5 - client 3 (again)

This query is working great and it does exactly what I want. In this
particular case I want to list all the contacts, including the clients who
had more than 1 meeting.

Now I want to build a new query (but I want do keep the query above) or a
report, that let me know just the contacted clients within the same period.
Following the example it should list:

record 1 - client 1
record 2 - client 2
record 3 - client 3

This is it. I should say that I don't want to lose the info of the 1st query.
I don’t want to lose the duplicates names. But the new query should list all
clients without duplicates, but I don't want to lose them. I can I do to
solve this issue. Should I do a report instead? Who can I do this?

Thanks for your help.

Ricardo

 

[Jim]

For the result you are interested in, it would seem that all you need to do
is build a second query based on the first. Select the "totals" query from
the design tab ribbon, include *only* the client field in the result, and
make sure it says "group by" in the "Total:" row underneath the field name.
And if you include the client field a second time and this time select
"Count" in the "Total:" row, you can have the number of meetings for each
client as well.

Jim

 

[rscosta]

Jim

Thanks for your answer but I can't make it work. I'm sure if I understood you.
I follow your instructions but in the 2nd query I still have duplicates.

Can you explain it a little better please?

Thanks

Ricardo

For the result you are interested in, it would seem that all you need to do
is build a second query based on the first. Select the "totals" query from
the design tab ribbon, include *only* the client field in the result, and
make sure it says "group by" in the "Total:" row underneath the field name.
And if you include the client field a second time and this time select
"Count" in the "Total:" row, you can have the number of meetings for each
client as well.

Jim

Hi

[quoted text clipped - 38 lines]

Ricardo

 

[rscosta]

Jim

Thanks for your answer but I can't make it work. I'm sure if I understood you.
I follow your instructions but in the 2nd query I still have duplicates.

Can you explain it a little better please?

Thanks

Ricardo

For the result you are interested in, it would seem that all you need to do
is build a second query based on the first. Select the "totals" query from
the design tab ribbon, include *only* the client field in the result, and
make sure it says "group by" in the "Total:" row underneath the field name.
And if you include the client field a second time and this time select
"Count" in the "Total:" row, you can have the number of meetings for each
client as well.

Jim

Hi

[quoted text clipped - 38 lines]

Ricardo

 

[rscosta]

Jim

Thanks for your answer but I can't make it work. I'm sure if I understood you.
I follow your instructions but in the 2nd query I still have duplicates.

Can you explain it a little better please?

Thanks

Ricardo

For the result you are interested in, it would seem that all you need to do
is build a second query based on the first. Select the "totals" query from
the design tab ribbon, include *only* the client field in the result, and
make sure it says "group by" in the "Total:" row underneath the field name.
And if you include the client field a second time and this time select
"Count" in the "Total:" row, you can have the number of meetings for each
client as well.

Jim

Hi

[quoted text clipped - 38 lines]

Ricardo