Thank you for replying so quickly to my question.
Unfortunately, I created my databases and THEN started
taking Access courses. This meant that I was correcting
all my errors as I went along (or tried to). Originally,
when I created my databases (about 10 of them), I created
a database for each client. Of course, now I know that
is not the way to do it. I then had trouble with the
append queries because the database field were not set up
the same way. (I hear you groaning!) So, instead of
trying to make all of the databases jive, I made a Master
database that was set up like it should be and then
copied the information into this database. I opened the
Master database and then used the "Get External Data" and
put the table into the tables in my Master. I then
opened the other database and copied column by column. I
created queries and tested them as I went along. At
first, the query was picking up the information, but it
did not pick all of the information from the all of the
different databases.
-----Original Message-----
By definition, a query is a statement that acts against
all the records in the query source. So, unless the top
values is set to some number that limits the result, the
query will always query the entire table (or source).
I am curious when you say you copied information from
another database. Did you append it to the existing table
when you brought it in? If you didn't append it, did you
make sure that the information went into the fields that
it was supposed to go into?
I know these are obvious questions, but there must be a
reason that your information isn't showing up, and
queries don't normally selectively include or exclude
records without outside intervention.
