Running a Query with Imported and New Data

[?QueryTroubles?]

Several months ago, I imported data (general demographic info) from an Excel
Spreadsheet into a simple Access database. Since then, I have added new data
(new customers, addresses, phone numbers, etc) to the same database. Upon
running a query, Access only pulls the old data and not any of the new data
that was added (even though the new data is shown in the database). How do I
get the query to pull from all data? Thanks, in advance, for your help!

 

[Eric D via AccessMonster.com]

First thought is that your newly entered records do not meet the criteria of
your query. You need to provide further information in order for someone to
provide further help.

Can you provide the query? Can you provide an examples of the imported
records and that of the new data?

 

[?QueryTroubles?]

The information that was imported from Microsoft into Excel is basic
demographic data, e.g. Name, Address, City, State, Zip, Phone Number, and
several different categories of support groups for various regions (which is
the basis for the query). The information that was subsequently added to the
database is the same as above - added to the same fields, etc. When I try to
run a query, though, for a particular support group in a region, it only
pulls the data from the Excel data that was originally imported and not any
of the new data that I added. It almost seems like the new data is invisible
to the query. Any help would be appreciated!

 

[Eric D via AccessMonster.com]

Are you doing any type of filtering within in your query in any way?
How many tables are involved? What are the relationships?
Are you filtering by a date entered? an ID field <= xxx?
When something like this happens to me, I usually start a new query, using
the same tables as the query that doesn't work. I start out with one field
and try to get the results I think I should. If I do, I add another field,
then another, etc. once I have all the fields for my query, if the results
are what I think they should be, I start adding my query criteria until I
find where my problem is located. I then dig deeper into this area.

Being that Excel and Access are designed to work with each other and without
any data to look at, I can only speculate.

The information that was imported from Microsoft into Excel is basic
demographic data, e.g. Name, Address, City, State, Zip, Phone Number, and
several different categories of support groups for various regions (which is
the basis for the query). The information that was subsequently added to the
database is the same as above - added to the same fields, etc. When I try to
run a query, though, for a particular support group in a region, it only
pulls the data from the Excel data that was originally imported and not any
of the new data that I added. It almost seems like the new data is invisible
to the query. Any help would be appreciated!

First thought is that your newly entered records do not meet the criteria of
your query. You need to provide further information in order for someone to

[quoted text clipped - 9 lines]

 

[?QueryTroubles?]

Eric, thanks for your continued help! Yes, we are filtering via one variable
within the table. So, we are hoping to pull all the names in a group based
upon their membership in that group (in a Yes/No field). There is only one
table involved. I will try taking everything apart and see if that helps.
Thanks for the suggestions...

Are you doing any type of filtering within in your query in any way?
How many tables are involved? What are the relationships?
Are you filtering by a date entered? an ID field <= xxx?
When something like this happens to me, I usually start a new query, using
the same tables as the query that doesn't work. I start out with one field
and try to get the results I think I should. If I do, I add another field,
then another, etc. once I have all the fields for my query, if the results
are what I think they should be, I start adding my query criteria until I
find where my problem is located. I then dig deeper into this area.

Being that Excel and Access are designed to work with each other and without
any data to look at, I can only speculate.

The information that was imported from Microsoft into Excel is basic
demographic data, e.g. Name, Address, City, State, Zip, Phone Number, and
several different categories of support groups for various regions (which is
the basis for the query). The information that was subsequently added to the
database is the same as above - added to the same fields, etc. When I try to
run a query, though, for a particular support group in a region, it only
pulls the data from the Excel data that was originally imported and not any
of the new data that I added. It almost seems like the new data is invisible
to the query. Any help would be appreciated!

First thought is that your newly entered records do not meet the criteria of
your query. You need to provide further information in order for someone to

[quoted text clipped - 9 lines]

that was added (even though the new data is shown in the database). How do I
get the query to pull from all data? Thanks, in advance, for your help!