Update query question

S

SugarBear

Hi

I have two database files. One has Structure that I want to keep as well
as a couple of new fields. The other is an earlier version, except that
someone did a bit of updating in it while I at work on the structure. My
question is this: I want to update the database that has the latest
structure and keep the new fields - they don't exist in the older
version. Can I do this with an update query?

Thanks

CH
 
M

[MVP] S. Clark

Yes.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

Hi

I have two database files. One has Structure that I want to keep as well
as a couple of new fields. The other is an earlier version, except that
someone did a bit of updating in it while I at work on the structure. My
question is this: I want to update the database that has the latest
structure and keep the new fields - they don't exist in the older
version. Can I do this with an update query?

Thanks

CH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Crosstab Query to Existing Table 0
Autonumber field in Excel that behaves the same as Access 0
Can't save my Office documents (after computer rebuild and reauthorization) 0
Updateable querie 2
How to update data in a query 1
Page numbering with Merged Document and IF statements 1
How do I clear a form? 0
Need Faster Query - 3073 evaded 4

Top