1) You have to learn something about DATABASE NORMALIZATION.
your table is not normalized.
2) Is there any other field after "F" (how many)?
3) Is there any data in A, B....... field?
4) Is there a PRIMARY KEY in table?
The table used an example above is a make table brought together from three smaller tables each using a primary key, each of the smaller tables consist of approximately 6 fields which all need to be brought together to be shown in the report format that i have shown above, each field contains data whether it be production figures, operating $, and capital $s associated with the period
What you want is a crosstab query. In the query design grid choose your table. Although it doesn't look like it will work with the three tables you have made. Hopefully you can do the Crosstab before the tables are made. If your data looks like:
Key Period Description Value
Then a crosstab is ideal. In this scenario, in query design add the table, then add the Period, Description and Value. THen change the query to a Crosstab and make Period the Column Heading, Description the Row Heading, and Value the Data (doing a sum on the Value). This should give you the format you need.