By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,455 Members | 2,293 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,455 IT Pros & Developers. It's quick & easy.

Append / Update Query

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.