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
A summary field will provide the sum for the found set. Seems like you will want a subsummary report grouped by date.
If you dont need the details, you can delete teh body part from teh subsummary report.
Do not forget to sort by the break field.