Calculations

[cjordan8]

My reports are based on queries that returns competitors for a given city, district or region. When the queries are run, all of the competitors are returned fine, they also return my own companies information for as many competitors there are in that city. I want to be able to show how many products we have in a city, district or region, so I set up a count. For example, if I run the query on Atlanta, and there are 3 competitors in Atlanta, the count for our own products is 3 even though there really is only one. I have the same problem when I try to sum revenues or any other information. How can I solve this?

 

[cjordan8]

essentially, how do i prevent duplicates from returning?

 

[3699wat]

I assume your query or queries are bound to more than one table. If so did you set the relationship right?

 

[cjordan8]

The queries are based on two tables. One that has information about competitors (which there are multiple for each city), and one that has information about our product which there is only one in each city. I've formed a relationship between city name. I really don't know much about relationships, so I might need to change them!