Creating a daily invoice report from invoice transactions table
I have a table that lists all of my sales invoices. I need to create a report every week and month that shows my daily sales activities for that time period. I'm not sure weather to create a script to populate another table, or if there is a way to create a layout with the existing invoice table that includes some sort of sub-summery part.
A google search turned up http://help.filemaker.com/app/answers/detail/a_id/790/~/creating-a-sub-summary-by-month. Can this also be used as a reference to create s sub-summery by day?