Autolookup Query

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?

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


"Patti Davignon" wrote 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?

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.

"Lynn Trapp" wrote:

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


"Patti Davignon" wrote 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?

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


"Patti Davignon" wrote in 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.

"Lynn Trapp" wrote:

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


"Patti Davignon" wrote 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?

Patti Davignon wrote:
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.

"Lynn Trapp" wrote:

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


"Patti Davignon" wrote 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?


I am going to take a guess. Do the records that are not showing up not
have a match in the other table?

--
Joseph E. Meehan

26 + 6 = 1 It's Irish Math

No they do not have a match. But I want to be able to add new records to the
instructor table, along with being able to lookup and autofill for the
existing ones.

"Joseph Meehan" wrote:

Patti Davignon wrote:
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.

"Lynn Trapp" wrote:

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


"Patti Davignon" wrote 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?


I am going to take a guess. Do the records that are not showing up not
have a match in the other table?

--
Joseph E. Meehan

26 + 6 = 1 It's Irish Math

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.

"Patti Davignon" wrote:

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


"Lynn Trapp" wrote:

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


"Patti Davignon" wrote in 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.

"Lynn Trapp" wrote:

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


"Patti Davignon" wrote 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?

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


"Lynn Trapp" wrote:

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


"Patti Davignon" wrote in 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.

"Lynn Trapp" wrote:

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


"Patti Davignon" wrote 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?

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


"Patti Davignon" wrote in message
...
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.

"Patti Davignon" wrote:

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


"Lynn Trapp" wrote:

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


"Patti Davignon" wrote in
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.

"Lynn Trapp" wrote:

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


"Patti Davignon" wrote
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?

Actually, that didn't work. It gave me a record in the query for every
record in the instructor table, there ALL there (792 of them!). Not just the
ones I want to look up plus it still won't let me enter new ones there are
not already existing. Thanks for trying to help though.

"Lynn Trapp" wrote:

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


"Patti Davignon" wrote in message
...
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.

"Patti Davignon" wrote:

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


"Lynn Trapp" wrote:

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


"Patti Davignon" wrote in
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.

"Lynn Trapp" wrote:

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


"Patti Davignon" wrote
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?