Updating combined querys

[cardimom]

I need to automatically refresh combined data from several querys from different databases on different servers. The data fields are exactly the same except for the server name which I need to compare data.I have made the same query for each server and correctly receive the data. I then return the query data to the same worksheet so I can compare it. The question is Can I update this data? I know it updates correctly when it is on separate worksheets (not combined) When I update it combined the data does change but it will repeat some lines several times. I cant figure out why is updates some of the data correctly but not all of it.

Thanks

 

[SkipVought]

Hi,

Can't read your mind.

What's the SQL?

How are you updating?

Give examples of source data and corresponding update results that you are having problems with.

Skip,

_{[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount!}