Search results

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...

I have two aggregate totals in the report footer that I would also like to divide so I can get a percentage. I built an expression that looked something like this. =Sum([Competitors.Revenue])/Sum([EG.Revenue]) and it returns a value of #NUM. What's going on?

I've never used if/then statements, but I think I need to now. I've got a report returning competitor information, including national totals. I want to be able to compare their totals with our totals without showing information about our offices in the competitor cities. The report shows...

Every time I run my query, I get the right results, but it returns them twice. So when I run my report based on that query, it also shows them twice. What to do?

I have a report and the source is a query that sorts competitors by city. In the competitor info there are numbers like distribution, circulation, and revenue. I want to be able to calculate totals for each city that will print at the bottom of the page listing the city and it's competitors...

I have 4 tables that must be linked together that all have the same information in them but for differnt competitors. I've created the city name as the primary key and created relationships between the 4 tables, but I would like to be able to enter data into one form with four tabs(1 for each...