I have a query joined together by two tables based on a [LocationCode] field. The first table “Locations” contains each location detail including [LocationCode] and [strGrossSqFt]. The query results shows the fields [LocationCode] and [strGrossSqFt] repeated thought-out the table wherever the tables are joined.
I am trying to create a report where the [LocationCode] is grouped and include the sum total of [strGrossSqFt]. However; the total of [strGrossSqFt] is multiplied by the number of time it is joined.
How can I show the results of [strGrossSqFt] field only once on my query?
I am trying to create a report where the [LocationCode] is grouped and include the sum total of [strGrossSqFt]. However; the total of [strGrossSqFt] is multiplied by the number of time it is joined.
How can I show the results of [strGrossSqFt] field only once on my query?
