Append / Update Query

[Melepoil]

Hi All,

I have a query to get selected fields from two tables in an SQl server.
I made a make query table to get these data to a table. Whenever there
is a change in the databse (the database get new records every minute!)
I always have to get all these downloaded to my table since it replaces
the table.

Is there a way to get to my current table only the new records from the
server by using a query? my query takes data from two tables.(both
table got several fields which are identical and some fields are not in
both tables)

Thanks

[Douglas J. Steele]

See whether the "Doing Two Things At Once" part of my November, 2003 Access
Answers column for Pinnacle Publication's Smart Access helps.

You can download the column (along with a sample database) for free at
http://www.accessmvp.com/djsteele/SmartAccess.html

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

<Me******@gmail.com> wrote in message
news:11*********************@g14g2000cwa.googlegro ups.com...

Hi All,

I have a query to get selected fields from two tables in an SQl server.
I made a make query table to get these data to a table. Whenever there
is a change in the databse (the database get new records every minute!)
I always have to get all these downloaded to my table since it replaces
the table.

Is there a way to get to my current table only the new records from the
server by using a query? my query takes data from two tables.(both
table got several fields which are identical and some fields are not in
both tables)

Thanks