Hi All,

I am having difficulty in creating a summary total of data in a related table.

1st Table (Comparison DB) contains the field "Site", "Machine Type", "Gross Revenue"

2nd Table (2002) contains the same fields but has hundreds of records because at any one site there can be multiple of the same machine type.

The relationship uses "Site" & "Machine Type"

The 1st table will only contain one unique record for each site and then machine type but needs to summarise the gross revenue from table 2 by machine type. This summary field needs to be placed in a report on table 1 (Comparison DB) but extract the data from table 2.

Is this possible ?

Hope somebody understands. It is quite difficult to explain.

Thanx

If I have truly understood you, try so.

Creat getsummary field in second table by "Site&" & "Machin Type"

Sort your recors for getting the value of this field

Create relation from second table to first.

Then by script put data from second table to first using relation.

This is one of ways.

There are other ways to do it using export or import.