Search results
-
C
Calculations
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... -
C
Calculations
essentially, how do i prevent duplicates from returning? -
C
Calculations
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... -
C
If Then's in report footer
No problem figured out what I needed to do! -
C
Query returning values twice
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... -
C
Query returning values twice
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! -
C
Query returning values twice
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... -
C
Query returning values twice
ALmost an infinte loop Now it's returning massive amounts of duplicates. How do I make it stop?:eek: -
C
Query returning values twice
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]... -
C
Query returning values twice
how? DO I have to send the whole database? -
C
If Then's in report footer
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... -
C
Query returning values twice
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? -
C
Calculating in queries
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! :) -
C
Calculating in queries
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... -
C
Calculating in queries
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... -
C
Calculating in queries
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.