RE: updating data

Santiago,

I am not familiar with teh interface between Access and Excel, but it sounds
like you are using some query syntax. If that is the case, the statement
that would do the update you want would look like this

Update tablename
Set ZipCode = XXXXX
Where City = Cityname

You could also do this via an update query in Access which wouldn't require
the typed out statement but provides a GUI for easier use.

If you are looking for a way to have it automatically back-update access
when you make the change in Excel, I can't help you - but I wouldn't be
surprise if that is something it won't do. I would grab your list of changed
zips and run a bunch of update queries against the main table in access
(either via the statement or using the query builder GUI.)

"Santiago" wrote:

> I need some help. I'm retreiving data from an access database to an excel
> work***. I run a query that uses "GROUP BY" (in SQL query). Then I update
> some data in the excel *** and would like to update it to Access again.
>
> For example: I have a huge client database with "City" "Country" "Zip Code"
> etc...
> I run a query that groups by "City" and brings "City" and "Zip Code"
> (Obviously there are a lot of clients of the same city). Then in the *** I
> would have 2 fields (City and Zip code) with a lot of records. Then I update
> all zip codes in Excel work***, and would like to update in the Access
> Database every city's zip code (that can be repeted in many records) from the
> Excel ***.
>
> Any idea how I can do this?
>
> thanks.
>
> bregards
>
> Santiago
.