hi, Heres a brief overview on wh

[crysma]

hi,

Heres a brief overview on what im trying to do: We have a databse with cusotmer information, including their address. we'd like to group the addresses by region, so that all addresses in cities A,B and C go in the South east region, cities D,E,F, go in the southwest, etc. There are about 22 cities, and aprox. 500 records.

I'm trying to create an update query that will fill in the appropriate value in the "Region" field based on the value in the city field. Is there any way to tell a query "If the city=x then Region=y"? Can anyone point me towards any other references?

thanks in advance,

Sheryll

 

[JeremyNYC]

Sheryll,

Check into help for Update Query. It's pretty easy to do what you want.

Jeremy =============
Jeremy Wallace
AlphaBet City Dataworks

http://www.AlphaBetCityDataworks.com

Take a look at the Developers' section of the site for some helpful fundamentals.