If your month field is of type "Date", you could:
Enter find mode
Enter 2/2009 in the month field (for all February 2009 records)
Perform the find
To see a grand total of all these records you just found, Define a summary field.
If you define the summary field as a total of your "total" field, it'll compute the grand total of that field.
If you look up Sub-Summary parts and learn how to use them, you can even use this field to show a monthly subtotal for a group of records that span more than a month.
thank you for teh quick reply
month field is of type "Date"
i have a summary field as a total of your "total" field
But when i try to generate a report its really off
so im at a complete loss and i dont know how to explain it any further.
say i want it to be catagorized by month. so it would look at all teh records in that month range.
and instead of having 20 diffrent dayes for that month it will just show up like this.
hours hourly rate total
Summary of all teh totals
I hope this is a little more clear to my previous explination
Check out sub-summary reports in the help file. The trick I'm about to outline creates that kind of report to do what you want.
- First, we need a field that has the same exact value for every record of the same month and year.
- Let's change your "Month" field name to "DateFld".
- Define a new Month field and define it as a calculation field set to return a Date type: Date ( Month ( DateFld ) ; 1 ; Year ( DateFld ) )
- Now go to your report layout, enter layout mode and use Layouts | Part Setup... to create a new layout part.
- Select "Sub-Summary when sorted by" and select the Month field. (You can choose the Print Below or Print Above option it doesn't matter which.)
- Click OK and Done to get back to the layout.
- Place the Month (or DateFld), Hours, hourly rate, Total (the summary field) in this new part.
- You can use Format | Date... to specify a date format for either Month or DateFld to show only the month/year.
- Click on the part label tab for your body layout part and press the delete key to delete it.
- Use Part Setup to add a Trailing Grand Summary Part to your layout.
- Add the same Total summary field to this layout part.
- Return to browse mode and sort your records by month.
- If you are using FMP 9 or older enter Preview Mode. In FMP 10, you can stay in Browse mode.
You should now see a report with one row per month, displaying a monthly total followed by a grand total at the bottom.
ththank you for teh help but im still screwed as i still cant figure this out. the help was very much appreciated.
If you can refer to my list of steps and let me know where you encounter trouble. I'll see if I can't elaborate the step in more detail.