Creating a "daily count" field

This is probably a stupid question.

I have a table, called "Sales", with 3 fields:

1) Customer Name (text)
2) Date of Sale (date)
3) Item Sold (text)

Customers can only buy one item per day.

So, now I all I want a simple table, called "Daily Sales Counts" that
summarizes the daily sales, with two fields:

1) Date
2) Item Sold
2) Total Number of Items sold, per Item

For example, if the table "Sales" has:
John Doe 12/1/07 Widget
Richard Roe 12/1/07 Gadget
Jane Joe 12/1/07 Widget
Bill Boe 12/2/07 Widget
Gary Goe 12/2/07 Widget
Mary Moe 12/2/07 Widget
Terry Toe 12/4/07 Widget
John Doe 12/6/07 Gadget

The table "Daily Sales Counts" would have:
12/1/07 Widget 2
12/1/07 Gadget 1
12/2/07 Widget 3
12/4/07 Widget 1
12/6/07 Gadget 1

I've been working all day it this, to no avail.

I would greatly appreciate any input, suggestions, advice, etc.! Many
thanks, in advance.

Re: Creating a "daily count" field

On 2007-12-25 15:33:18 -0800, Jim Schwartz said:

> I've been working all day it this, to no avail.
>
> I would greatly appreciate any input, suggestions, advice, etc.! Many
> thanks, in advance.

Hey, it's Christmas. Give it a rest!

But when you resume tomorrow, you'll want to look up "subsummary report."

Create a summary field defined as a total of unit sales.

On your report layout, create a subsummary part sorted by date. Create
a second subsummary part sorted by Item. Put the Date field in the
first part, put the Item field in the second part, as well as the Unit
Summary field. This report has no body part.

Now, find your set of records you want to report on, sort first by
date, then by item, and view the report in Preview mode, or print it.
If you sort in the reverse order, you'll see the same report appear
differently, with Items then summarized by the list of sales per day.

You can also add a trailing Grand Summary part at the end and include
only the summary field, and you'll get a total of sales.
--
Lynn Allen
--
www.semiotics.com
Member Filemaker Business Alliance
Long Beach, CA

Re: Creating a "daily count" field

In article <4771d043@news.bnb-lp.com>, Lynn Allen
wrote:
>
> Hey, it's Christmas. Give it a rest!


Bah, humbug!!! Christmas is just another day. ;o)

Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)