Count number of clients

[kittyfool]

I got a sales performace report. I need to track how many customers each of
my sales staff have in each month.

However, from my raw data, there are duplicates customer ID. How can i sort
them uniquely by month and by each sales staff?

And the report need to have a breakdown of their product sales each month.

Any help is appreciated.
Thanks

 

[Al Campagna]

kitty,
That would be a bit easier if we could see a few lines of sample/duplicate data, and
what tables those fields are in, and the realtionship of those fields.
But...
Have you tried a "Totals" query? In query Design mode select View/Totals
Salesperson CustomerID
GroupBy Count

 

[kittyfool]

Hi Campagna,
My data in the table is as follow.
In my query i have use group by total. But i cant count the unique values.

http://i51.photobucket.com/albums/f383/kittyfool/data.jpg
http://i51.photobucket.com/albums/f383/kittyfool/report.jpg

any help is appreciated.

kitty,
That would be a bit easier if we could see a few lines of sample/duplicate data, and
what tables those fields are in, and the realtionship of those fields.
But...
Have you tried a "Totals" query? In query Design mode select View/Totals
Salesperson CustomerID
GroupBy Count

I got a sales performace report. I need to track how many customers each of
my sales staff have in each month.

[quoted text clipped - 6 lines]

Any help is appreciated.
Thanks

 

[Al Campagna]

kitty,
It appears as though the data you show is not the result of running the query you show.
Does your query deliver the right "raw" data? (before totaling and summing). In other
words, using a Select query to start with, do you retrieve the raw records you want to
total?

It appears as though your trying to sum AUM in a "psuedo" crosstab query, that you
derive by creating a field across for each month.

I'd like to see "raw" Select Query data, and an example of what you want to see after
the coverting that to a Total query... with some example totals.
(What you have now vs. what you want to see)
It's looks OK, but I'm a bit confused as to what you want for output.
--------------------------------------------------
Or, if you want, you can send me a small mdb file (compacted and zipped) with just the
tables and report we need for this problem.
Please indicate here that you sent it... and what version of Access.
I insure confidentiality, no charge, on a "will try"... "when I can"... basis.
Use my web site "Contact" to send.. http://home.comcast.net/~cccsolutions
--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

Hi Campagna,
My data in the table is as follow.
In my query i have use group by total. But i cant count the unique values.

http://i51.photobucket.com/albums/f383/kittyfool/data.jpg
http://i51.photobucket.com/albums/f383/kittyfool/report.jpg

any help is appreciated.

kitty,
That would be a bit easier if we could see a few lines of sample/duplicate data, and
what tables those fields are in, and the realtionship of those fields.
But...
Have you tried a "Totals" query? In query Design mode select View/Totals
Salesperson CustomerID
GroupBy Count

I got a sales performace report. I need to track how many customers each of
my sales staff have in each month.

[quoted text clipped - 6 lines]

Any help is appreciated.
Thanks

 

[kittyfool via AccessMonster.com]

hi Campagna,

i have send you the compact file through the email in your website.
Thanks for your help.

kitty,
It appears as though the data you show is not the result of running the query you show.
Does your query deliver the right "raw" data? (before totaling and summing). In other
words, using a Select query to start with, do you retrieve the raw records you want to
total?

It appears as though your trying to sum AUM in a "psuedo" crosstab query, that you
derive by creating a field across for each month.

I'd like to see "raw" Select Query data, and an example of what you want to see after
the coverting that to a Total query... with some example totals.
(What you have now vs. what you want to see)
It's looks OK, but I'm a bit confused as to what you want for output.
--------------------------------------------------
Or, if you want, you can send me a small mdb file (compacted and zipped) with just the
tables and report we need for this problem.
Please indicate here that you sent it... and what version of Access.
I insure confidentiality, no charge, on a "will try"... "when I can"... basis.
Use my web site "Contact" to send.. http://home.comcast.net/~cccsolutions

Hi Campagna,
My data in the table is as follow.

[quoted text clipped - 18 lines]

 

[Al Campagna]

Kitty,
Haven't seen that file show up yet. Please try again, and put "newsgroups" in the
subject
and
I need you to do your best to answer this question....--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

hi Campagna,

i have send you the compact file through the email in your website.
Thanks for your help.

kitty,
It appears as though the data you show is not the result of running the query you
show.
Does your query deliver the right "raw" data? (before totaling and summing). In
other
words, using a Select query to start with, do you retrieve the raw records you want to
total?

It appears as though your trying to sum AUM in a "psuedo" crosstab query, that you
derive by creating a field across for each month.

I'd like to see "raw" Select Query data, and an example of what you want to see after
the coverting that to a Total query... with some example totals.
(What you have now vs. what you want to see)
It's looks OK, but I'm a bit confused as to what you want for output.
--------------------------------------------------
Or, if you want, you can send me a small mdb file (compacted and zipped) with just
the
tables and report we need for this problem.
Please indicate here that you sent it... and what version of Access.
I insure confidentiality, no charge, on a "will try"... "when I can"... basis.
Use my web site "Contact" to send.. http://home.comcast.net/~cccsolutions

Hi Campagna,
My data in the table is as follow.

[quoted text clipped - 18 lines]

Any help is appreciated.
Thanks