Ok...now we are starting to get somewhere. Where it says "INNER JOIN",
change that to "LEFT JOIN" and see if that doesn't give you what you want.
--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security:
www.ltcomputerdesigns.com/Security.htm
I think I may have figured out the problem, but I'm not sure how to solve
it.
In the form that is based on the query, I not only want to "lookup" the
information from the instructor table and have it fill in, but for the
records in my class database that I may not have the instructor for yet, I
have to leave the instructor field blank. The query is only giving me the
results of the records that are MATCHING in each table. So if I don't
have
an instructor to list, or if its a new instructor who is not listed in the
instructor table, it isn't showing them on the query. So what I want it
to
do is list all of them in the class table, whether or not it has an
instructor. Understand? Let me know if this helps you.
:
SELECT [Fall 2004].Semester, [Fall 2004].[CE #], [Fall 2004].[Section
#],
[Fall 2004].Price, [Fall 2004].[Materials Fee], [Fall 2004].[Start
Date],
[Fall 2004].[End Date], [Fall 2004].[Min/Max], [Fall 2004].Time, [Fall
2004].Admin, [Fall 2004].Category, [Fall 2004].[Day(s)], [Fall
2004].Skip,
[Fall 2004].Weeks, [Fall 2004].Hours, [Fall 2004].Location, [Fall
2004].[Room
Reservation #], [Fall 2004].Title, [Fall 2004].EventDescription, [Fall
2004].[Food?], [Fall 2004].[Instructor Description], [Fall
2004].Instructor,
[Fall 2004].[Date Paid], [Fall 2004].Salary, [Fall 2004].Dates, [Fall
2004].Instructor2, [Fall 2004].Salary2, [Fall 2004].Dates2, [Fall
2004].Instructor3, [Fall 2004].Salary3, [Fall 2004].Dates3, [Fall
2004].[Room
Setup/Equipment/Media], [Instructor Information].Company, [Instructor
Information].Address, [Instructor Information].City, [Instructor
Information].State, [Instructor Information].Zip, [Instructor
Information].[Home Phone], [Instructor Information].[Work Phone],
[Instructor
Information].[Cell Phone], [Instructor Information].[Email Address]
FROM [Instructor Information] INNER JOIN [Fall 2004] ON [Instructor
Information].Instructor = [Fall 2004].Instructor;
Ok Hope this helps
:
Ok, that helps a little bit. If you will open your query in design
view,
then select View > SQL View it will switch to a text based view. Copy
and
paste that here.
--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security:
www.ltcomputerdesigns.com/Security.htm
message
Sorry, I didn't mean to be so vague. I'm not sure what you mean by
the
SQL
for my query. The "autolookup" query I created is a combination of
data
from
two different tables. I have an instructor table and a class table.
The
query is used to create an "autofill" feature on the form I use.
However,
I'm not having a problem with the autofill part of it. The problem
is
that
in my query I have not specified any criteria because I don't want
to
exclude
any records. The query is just not showing all of the records in
the
table
as it should.
:
We might be able to help but we need a lot more information from
you.
What
do you mean by "an autolookup query"? What do you mean by "files
in my
database"? A database stores records not files. Would you post the
SQL
for
your query?
--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security:
www.ltcomputerdesigns.com/Security.htm
in
message
I have created an autolookup query to lookup instructor
information in
my
instructor database. However, when I open the query, it is not
showing
all
of the files in my database. I have not sent any criteria
because I
want
to
show all of my records. Can someone help?
