How can we make a summary field dependent on date?
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