Recent content by cjordan8
-
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?