Subtotals and Totals

[fperezl]

Hi,

I am having a hardtime with filemaker. Here is my problem lets see if someone sees it

I am farmer who wants to record the activities (for example : irrigation, plantation, etc ) performed in the farm. I have sectioned or divided the farm in 5 sections and subsections. Therefore, i will have section 1 with 2 subsections = 1-1 and 1-2. Section 2, subsections 2-1, 2-2. Each sections has a number of acres and each subsection has a fraction of the section. So, for example section 1 will have in total 5 acres but divided in 1-1 with 2 acres, and subsection 1-2 with 3 acres.

In the end i will want to record the activities performed daily and be able to summarize how many acres in the different activities i performed in the day with a total.

In my database I created 1 table with the acres that each subsection has. So, basically i have a field called subsection and another called acres.

Subsection 1-1

acres 2

Subsection 1-2

acres 3

I have also created another table that is related to the subsections so automatically when i select the labor it shows me the acres.

My problem is that when i trie to summarize the activities in a subsection in takes the acres and adds them over and over. I dont know how to create a subtotal of the particular acres i rrigated or prepared, etc.

Well, i hope someone finds this interesting because obviuosly it applies to everyone's life in the different areas of work. Today, it may be agriculture, later it can be something else..

I appreciate any help offered..

cheers

Edited February 25, 2006 by Guest