|
Home > Archive > MS Access database support > July 2005 > DCount, by customer
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
DCount, by customer
|
|
| teresaalmond@hotmail.com 2005-07-27, 8:25 pm |
| I'm trying to create a report.. or qry.. or spreadsheet.. anything that
will give me a count of types of machines purchases per customer. I've
already created a table with all the info for the date range I'm
looking at to make it easier to query (there are a LOT of records) I
thought I could use DCount but then I realized it was counting totals.
I need to count totals per customer.
For example
# of New excavators
# of Used excavators
# of Our Brand exc..
# of other Brand exc..
# of our Brand exc used..
# of other Brand exc new...
the criteria is easy enough.. i have a manufacturer, machine status
(new/used), etc to get the right machines.. I just can't seem to figure
out how to get a count in each category, for each customer.
Help me please?
tess@conwaycorp.net
thanks in advance
| |
| Br@dley 2005-07-27, 8:25 pm |
| teresaalmond@hotmail
.com wrote:
> I'm trying to create a report.. or qry.. or spreadsheet.. anything
> that will give me a count of types of machines purchases per
> customer. I've already created a table with all the info for the date
> range I'm looking at to make it easier to query (there are a LOT of
> records) I thought I could use DCount but then I realized it was
> counting totals. I need to count totals per customer.
> For example
>
> # of New excavators
> # of Used excavators
> # of Our Brand exc..
> # of other Brand exc..
> # of our Brand exc used..
> # of other Brand exc new...
>
> the criteria is easy enough.. i have a manufacturer, machine status
> (new/used), etc to get the right machines.. I just can't seem to
> figure out how to get a count in each category, for each customer.
>
> Help me please?
>
> tess@conwaycorp.net
>
> thanks in advance
You need to group by each category in your report (View/Sorting and
Grouping in the menu). Make sure Group footer is set to ON. Then in each
group's footer put a field that sums the values.
--
regards,
Bradley
A Christian Response
http://www.pastornet.net.au/response
|
|
|
|
|