Is it update query that will do this?

[Frank Situmorang]

Hello,

Our denomination has database for each chrurch. In the regional office level
all table from churchse will be combined.

What query should be used to handle the following example

REc No. Name Address
1 Mr. Wilcox 32 Redlands, Jakarta

This is alfready sent to regional office.

Now the chrurces found out later that the same record has a misspelling the
words of address it should be 21, Rodeland, Jakarta

So when the same chruch will send it/s data, what query to be used in order
the same record to update the misspelling the address.

Thanks for any advice


And the the same record has a change in the

 

[Clifford Bass]

Hi Frank,

Making progress I see. How do you know which records have been updated
since the data was (last) sent?

Clifford Bass