Search results

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

essentially, how do i prevent duplicates from returning?

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

never mind...i'm an idiot.

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?

No problem figured out what I needed to do!

Having the cartesian problem again with two different tables. My query searches by city for all the competitors. I want to be able to show my company's information for that city as well without showing all of the fields, so I have sum functions in the report footer. I've connected the two...

I think I figured out the problem. I connected the cities on the last two tables and the competitor names on the national level and the local level. all appears well, but that could change. Thanks for your help!

The problem is I have 3 tables. 1 with general information about our national major competitors that is put in the header of the report. The second with all the competitor information by city, and the third with our own companies information by city. When I join the second and third together...

ALmost an infinte loop Now it's returning massive amounts of duplicates. How do I make it stop?:eek:

thanks, i'm learning i promise SELECT Competitors.ID, Competitors.City, Competitors.Competitor, Competitors.Owner, Competitors.Company, Competitors.[Based out of], Competitors.[Coverage Area], Competitors.[Distribution - say], Competitors.[Distribution - think], Competitors.[Circulation - say]...

how? DO I have to send the whole database?

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

now it's returning them 4 times

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 am an idiot...just noticed that there was a difference between report and page footer. I'll have more questions soon as the boss decides and then changes his mind about what he wants! :)

page footer

I took your advice HTH, but I keep getting an error message when I go to view the report. In Design view, I named the bound object(not the label) txtRev, then went down to the footer, created a new text box and in the unbound object there typed =Sum([txtRev]). When I go to view it, I see the...

I think I'm a total idiot, because even with your help I can't figure it out. Is there anyway to create a field that will just be the sum of other fields. FOr example. When I run my query, it prompts me for the city so I just see competitors for one city. I want to be able to total the...

To be honest, I don't really know how to use grouping. Everything I know about access is just from messing around with it, and I've never had occasion to do calculations before now.