Query problems

  • Thread starter Thread starter JHolguin85
  • Start date Start date
J

JHolguin85

Okay, all I need access to do is pull up al the notes and dates they were
taken from all of the tables in a file. I keep running into the problem that
it will give me 850 results because it will spit out every possible
combination on note and date. I would like to be able to narrow it down to
run between specific dates, but I need to get to point A before I can get to
point B. If anyone can tell me what I'm doing wrong and how I can fix it I
would really apreciate the help.
 
We aren't there.

We can't see your "tables".

"How" depends on "what".

What are you working with?

What does your current query's SQL statement look like?

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
We aren't there.

We can't see your "tables".

"How" depends on "what".

What are you working with?

What does your current query's SQL statement look like?

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Okay, all I need access to do is pull up al the notes and dates they were
taken from all of the tables in a file. I keep running into the problem that
it will give me 850 results because it will spit out every possible
combination on note and date. I would like to be able to narrow it down to
run between specific dates, but I need to get to point A before I can get to
point B. If anyone can tell me what I'm doing wrong and how I can fix it I
would really apreciate the help.
Click to expand...

We'll be glad to tell you what you're doing wrong if you'll tell us what
you're doing. We can't see your screen!

Please post a description of your tables, how they are related, and the SQL
view of the query you're using. It sounds like you have a query without a JOIN
but that's a pure guess.
 
Okay, all I need access to do is pull up al the notes and dates they were
taken from all of the tables in a file. I keep running into the problem that
it will give me 850 results because it will spit out every possible
combination on note and date. I would like to be able to narrow it down to
run between specific dates, but I need to get to point A before I can get to
point B. If anyone can tell me what I'm doing wrong and how I can fix it I
would really apreciate the help.
Click to expand...

We'll be glad to tell you what you're doing wrong if you'll tell us what
you're doing. We can't see your screen!

Please post a description of your tables, how they are related, and the SQL
view of the query you're using. It sounds like you have a query without a JOIN
but that's a pure guess.
 
Basically, it's set up so that there are 8 companies with 6 columns for
information. I came in thsi morning to find that all of my members columns
have been linked up, but I have no idea how or why this happened. Let me
know what other info you need.

Thanks,
Jessica Holguin

The SQL reads:

SELECT tblBlueRidgeSupply.[Date of Notes], tblBlueRidgeSupply.Notes,
tblCascadeVentures.[Date of Notes], tblCascadeVentures.Notes,
tblElkViewProperties.[Date of Notes], tblElkViewProperties.Notes,
tblLaserArtCreations.[Date of Notes], tblLaserArtCreations.Notes,
tblOakHillProperties.[Date of Notes], tblOakHillProperties.Notes,
tblSmokyTopConstruction.[Date of Notes], tblSmokyTopConstruction.Notes,
tblSwedeInvestments.[Date of Notes], tblSwedeInvestments.Notes,
tblValleyTopDevelopers.[Date of Notes], tblValleyTopDevelopers.Notes
FROM ((((((tblBlueRidgeSupply INNER JOIN tblCascadeVentures ON
tblBlueRidgeSupply.Members = tblCascadeVentures.Members) INNER JOIN
tblElkViewProperties ON tblBlueRidgeSupply.Members =
tblElkViewProperties.Members) INNER JOIN tblLaserArtCreations ON
tblBlueRidgeSupply.Members = tblLaserArtCreations.Members) INNER JOIN
tblOakHillProperties ON tblBlueRidgeSupply.Members =
tblOakHillProperties.Members) INNER JOIN tblSmokyTopConstruction ON
tblBlueRidgeSupply.Members = tblSmokyTopConstruction.Members) INNER JOIN
tblSwedeInvestments ON tblBlueRidgeSupply.Members =
tblSwedeInvestments.Members) INNER JOIN tblValleyTopDevelopers ON
tblBlueRidgeSupply.Members = tblValleyTopDevelopers.Members;
 
Basically, it's set up so that there are 8 companies with 6 columns for
information. I came in thsi morning to find that all of my members columns
have been linked up, but I have no idea how or why this happened. Let me
know what other info you need.

Thanks,
Jessica Holguin

The SQL reads:

SELECT tblBlueRidgeSupply.[Date of Notes], tblBlueRidgeSupply.Notes,
tblCascadeVentures.[Date of Notes], tblCascadeVentures.Notes,
tblElkViewProperties.[Date of Notes], tblElkViewProperties.Notes,
tblLaserArtCreations.[Date of Notes], tblLaserArtCreations.Notes,
tblOakHillProperties.[Date of Notes], tblOakHillProperties.Notes,
tblSmokyTopConstruction.[Date of Notes], tblSmokyTopConstruction.Notes,
tblSwedeInvestments.[Date of Notes], tblSwedeInvestments.Notes,
tblValleyTopDevelopers.[Date of Notes], tblValleyTopDevelopers.Notes
FROM ((((((tblBlueRidgeSupply INNER JOIN tblCascadeVentures ON
tblBlueRidgeSupply.Members = tblCascadeVentures.Members) INNER JOIN
tblElkViewProperties ON tblBlueRidgeSupply.Members =
tblElkViewProperties.Members) INNER JOIN tblLaserArtCreations ON
tblBlueRidgeSupply.Members = tblLaserArtCreations.Members) INNER JOIN
tblOakHillProperties ON tblBlueRidgeSupply.Members =
tblOakHillProperties.Members) INNER JOIN tblSmokyTopConstruction ON
tblBlueRidgeSupply.Members = tblSmokyTopConstruction.Members) INNER JOIN
tblSwedeInvestments ON tblBlueRidgeSupply.Members =
tblSwedeInvestments.Members) INNER JOIN tblValleyTopDevelopers ON
tblBlueRidgeSupply.Members = tblValleyTopDevelopers.Members;
 
Basically, it's set up so that there are 8 companies with 6 columns for
information. I came in thsi morning to find that all of my members columns
have been linked up, but I have no idea how or why this happened. Let me
know what other info you need.

Thanks,
Jessica Holguin

The SQL reads:

SELECT tblBlueRidgeSupply.[Date of Notes], tblBlueRidgeSupply.Notes,
tblCascadeVentures.[Date of Notes], tblCascadeVentures.Notes,
tblElkViewProperties.[Date of Notes], tblElkViewProperties.Notes,
tblLaserArtCreations.[Date of Notes], tblLaserArtCreations.Notes,
tblOakHillProperties.[Date of Notes], tblOakHillProperties.Notes,
tblSmokyTopConstruction.[Date of Notes], tblSmokyTopConstruction.Notes,
tblSwedeInvestments.[Date of Notes], tblSwedeInvestments.Notes,
tblValleyTopDevelopers.[Date of Notes], tblValleyTopDevelopers.Notes
FROM ((((((tblBlueRidgeSupply INNER JOIN tblCascadeVentures ON
tblBlueRidgeSupply.Members = tblCascadeVentures.Members) INNER JOIN
tblElkViewProperties ON tblBlueRidgeSupply.Members =
tblElkViewProperties.Members) INNER JOIN tblLaserArtCreations ON
tblBlueRidgeSupply.Members = tblLaserArtCreations.Members) INNER JOIN
tblOakHillProperties ON tblBlueRidgeSupply.Members =
tblOakHillProperties.Members) INNER JOIN tblSmokyTopConstruction ON
tblBlueRidgeSupply.Members = tblSmokyTopConstruction.Members) INNER JOIN
tblSwedeInvestments ON tblBlueRidgeSupply.Members =
tblSwedeInvestments.Members) INNER JOIN tblValleyTopDevelopers ON
tblBlueRidgeSupply.Members = tblValleyTopDevelopers.Members;
Click to expand...

If you have six tables for six different companies... your database structure
IS WRONG.

What will you do if you take another company under contract? Rewrite all your
queries, redesign your forms, etc. etc.? The company should be stored AS DATA;
you need *one* table with these six fields, and one additional field to
identify the company.

I don't know what the "Members" field contains, but I very much doubt it's a
proper primary/foreign key.

Take a look at some of the tutorials and guides at:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/

A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials
 
Basically, it's set up so that there are 8 companies with 6 columns for
information. I came in thsi morning to find that all of my members columns
have been linked up, but I have no idea how or why this happened. Let me
know what other info you need.

Thanks,
Jessica Holguin

The SQL reads:

SELECT tblBlueRidgeSupply.[Date of Notes], tblBlueRidgeSupply.Notes,
tblCascadeVentures.[Date of Notes], tblCascadeVentures.Notes,
tblElkViewProperties.[Date of Notes], tblElkViewProperties.Notes,
tblLaserArtCreations.[Date of Notes], tblLaserArtCreations.Notes,
tblOakHillProperties.[Date of Notes], tblOakHillProperties.Notes,
tblSmokyTopConstruction.[Date of Notes], tblSmokyTopConstruction.Notes,
tblSwedeInvestments.[Date of Notes], tblSwedeInvestments.Notes,
tblValleyTopDevelopers.[Date of Notes], tblValleyTopDevelopers.Notes
FROM ((((((tblBlueRidgeSupply INNER JOIN tblCascadeVentures ON
tblBlueRidgeSupply.Members = tblCascadeVentures.Members) INNER JOIN
tblElkViewProperties ON tblBlueRidgeSupply.Members =
tblElkViewProperties.Members) INNER JOIN tblLaserArtCreations ON
tblBlueRidgeSupply.Members = tblLaserArtCreations.Members) INNER JOIN
tblOakHillProperties ON tblBlueRidgeSupply.Members =
tblOakHillProperties.Members) INNER JOIN tblSmokyTopConstruction ON
tblBlueRidgeSupply.Members = tblSmokyTopConstruction.Members) INNER JOIN
tblSwedeInvestments ON tblBlueRidgeSupply.Members =
tblSwedeInvestments.Members) INNER JOIN tblValleyTopDevelopers ON
tblBlueRidgeSupply.Members = tblValleyTopDevelopers.Members;
Click to expand...

If you have six tables for six different companies... your database structure
IS WRONG.

What will you do if you take another company under contract? Rewrite all your
queries, redesign your forms, etc. etc.? The company should be stored AS DATA;
you need *one* table with these six fields, and one additional field to
identify the company.

I don't know what the "Members" field contains, but I very much doubt it's a
proper primary/foreign key.

Take a look at some of the tutorials and guides at:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/

A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials
 
Back
Top