Count of Sales by Salesperson -Summary?

[rforster]

Hi all,

Basic stuff here but cant make this work.

Trying to get a count of invoices for each salesperson. Made a summary field called count_salesperson and in options made a count of Salesperson.

I made a layout and got a unsorted list of sales people with the same count. Close but after trying 4 or 5 layouts I cant get it to count the number of invoices each person did and give me a list.

I think the problem starts w my summary field being wrong. Last time i really had to play with data it was a query of the table, group by the field, and sort.

Thanks for any help.

[rforster]

This can't be that hard to do? Or did I post in the wrong section?

[efen]

See attsched - you need a total, not count

sales.zip

[rforster]

Hey thanks! That gave me an example but what I want to know is how many invoices did brown write? I flipped through the them records and it's 3.

My "report" should just show:

Brown: 3

Blue: 2

Red: 1

I need to add an auto entry for each record that = 1? Just to do a count?