Hi, I have created two tables; one with the names of people owning farms and the other has the list of crops on the farms (intercropped). I have also created the relationship linking the two tables and then a query combinining the unique number given to each farm and the tree types found on each farm.

I want to create a report that prints each intercropping as it were one record (see image 2), however, the crops are in different records in my query (see image 1).

NOTE: One farm can have more than one intercrpping set i.e for example an owner has 10 acres there are cases where 3 acres are planted maize and sorgum, 5 acres are planted maize and sunflower and 2 acres are planted with cassava and groundnuts.


I need the report to appear as under

Intercropping                             Area (acres)

Maize (60%), Sorgum (40%)                 3

Maize (30%), Sunflower (25%)              5

Cassava (75%), Groundnuts (80%)           2