DCount, by customer

[teresaalmond@hotmail.com]

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]

Re: DCount, by customer

teresaalmond@ho tmail.com wrote:[color=blue]
> 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[/color]

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