AnsweredAssumed Answered

How can we make a summary field dependent on date?

Question asked by rickscarborough on Oct 11, 2009
Latest reply on Oct 12, 2009 by mrvodka

Title

How can we make a summary field dependent on date?

Post

Hi

   We are moving our small business reservation system from paper to a Filemaker 10 Pro database on Mac OSX with input by phone receptionist.

 

We have a "date of reservation" field and a "number of guests" field.

 

How can we make a summary field for "number of guests" sum only the records for duplicate dates.  We would like the field to display the total number of

guests for the particular date of the record.

 

We are also asking for help to get a layout/report that has a list/table of dates showing the sum total of number of guests for each date.

 

Thanks for any help

 

Rick   www.bardchuckwagon.com 

Outcomes