Append two tables

[Aurora]

I am using Access 2003.
I am trying to append two tables. One table has a list of new customers as
of June, 2008 and the other table has new customers from June through now. I
tried doing an "Apend Query" but I must be missing a something because it is
not working. My "Help" screen was of NO Help. I can't find the MS training
module to try to see what I am doing wrong. Can anyone point me the right
direction for learning how to do an append query or am I trying to do the
wrong query?

Aurora

 

[Dirk Goldgar]

I am using Access 2003.
I am trying to append two tables. One table has a list of new customers
as
of June, 2008 and the other table has new customers from June through now.
I
tried doing an "Apend Query" but I must be missing a something because it
is
not working. My "Help" screen was of NO Help. I can't find the MS
training
module to try to see what I am doing wrong. Can anyone point me the right
direction for learning how to do an append query or am I trying to do the
wrong query?

This sort of thing is easier to diagnose if you explain exactly what you
mean by "not working" -- error message? No error, but no output? Output,
but not what you expected? Also, it helps to know what you've tried. Since
you're talking about a query, usually it's helpful to post the SQL View of
the query.

Without that info, I'll ask some questions about what you're trying to do.

1. Are you trying to append one of those two tables to the other, or are you
trying to append the contents of both of them to a third table?

2. What table are you trying to append to? If it's a third table, does it
already exist?

3. Do the tables have exactly the same structure?

 

[Aurora]

Dick:

Thank you for responding. I went back into the query, so that I could
explain what was happening and realized that I forgot to click on "RUN".
There are days, when it does not pay to get out of bed. But thank you any
way for trying to help me.

aurora

 

[Dirk Goldgar]

Dick:

Thank you for responding. I went back into the query, so that I could
explain what was happening and realized that I forgot to click on "RUN".
There are days, when it does not pay to get out of bed.

<g> Don't I know it!