Jumat, 02 September 2011

[MS_AccessPros] Compare, match and append rows in two tables

 

Hi,

I'm new to VBA and new to this group. My co-worker Liz Ravenwood told me I'd get great results if I posted my issue to this group!

This is what I'm trying to do. I have two tables in Access.

Table one is in this order:

Field2 Field4 Field5 Field7... up to 42 columns and over 1000 rows.

Table two is in this order:

Field1 Field2 Field3 Field4... etc.

In each table, th first row of each column has the word that needs to match. All the column data that matches in table two needs to be appended to the matching field in table one.

Can this be done in Access or is it more of an Excel issue?

Thank you.

Sally
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

[Non-text portions of this message have been removed]

__._,_.___
Recent Activity:
MARKETPLACE
A bad score is 598. A bad idea is not checking yours, at freecreditscore.com.

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

.

__,_._,___

Tidak ada komentar:

Posting Komentar