1 Reply Latest reply on Oct 12, 2009 9:28 AM by mrvodka

    How can we make a summary field dependent on date?

    rickscarborough

      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