Action Queries are not working properly

  • Thread starter Thread starter Joseph Ellis
  • Start date Start date
J

Joseph Ellis

Hello, all. I'm relatively new to Access, so please
forgive my ignorance.

I have a small database of church members consisting in
part of a table of contact information for about 200
individuals. 23 of those individuals have email
addresses. I'm trying to use a Make-Table query to
assemble the First Name, Last Name, and E-Mail Address of
each individual into a new table that I'll then import
into Outlook for e-mailing purposes.

When I run this query, it generates a new table
containing the fields "First Name", "Last Name", and "E-
Mail Address". So far so good.

The problem is that the 23 records assembled in this
table are all identical, containing the
values "First", "Last", and "Email Address", respectively.

I've made some screenshots that may help explain the
problem: http://www.texasellis.com/pub/query

In the course of building this database, I have changed
the names of the fields a few times, with the
understanding that Access 2002 could handle it, but that
doesn't seem to be the case. How do I fix this? I've
tried creating a new database, then importing the data
from the old database into the new, but I think I'm just
importing corrupt data. Am I going to have to re-enter
all the data by hand into a newly created database?

Thanks for any suggestions.
 
Joseph,

Your screen shots made it very helpful. What I did notice is
that the only records in queryresults2 that had anything in
the email field were the records that all have First Name,
Last Name and Email Address as the data. I don't see any
major problems with your query design.

Look in your table directly and see if you see the same
thing with those records when you sort by last name. My
guess is that you will see those results there as well and
there may be some kind of problem when a record with an
email is added. Is this being done with some code on a form
or could the Default Values say 'Email Address'? The first
query is consistent with the second as the only records with
the email address that you were filtering for all have
'Email Address' in the email field.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
 
Back
Top