Appending Records without creating table

  • Thread starter Thread starter ChuckW
  • Start date Start date
C

ChuckW

Hi,

I have two different transaction tables that have the
exact same fields. One of them is for people who we
extend credit to and the other is for people who pay by
credit card. I want to create one query that appends both
tables so I get all transactions regardless of payment
type. The only way I know how to do this is to create a
make table out of one and append the other table to it.

The problem is that I am building an application using
forms and I would rather have some kind of query that
would combine data from the two tables without have to go
through this. I would like to have a button on a form
that when pressed run a query on the combined data. One
problem with my method is that these messages pop up
saying "You are about to paste 4563 records into a table -
is this OK". I dont know how to hide this from the
user. Also, I would only want to append my combined
table with new transactions.

Can anyone offer any ideas on this?

Thanks,

Chuck
 
I want to create one query that appends both
tables so I get all transactions regardless of payment
type.
Click to expand...

Use a UNION query: see the online help for UNION, that's exactly what
it's designed to do.
 
Back
Top