From: Dan on 4 Mar 2010 16:01
Jerry, you made my day. I don't know why I couldn't put the puzzle pieces
together. I was close but couldn't get past the idea of using a query for
some reason. Thank you very much for your help.
"Jerry Whittle" wrote:
> You can't put in the city names into your Main table (short of a lookup field
> which do do NOT want to do). However you can display the city names in a
> Open a new query in Design view.
> Select both of the tables.
> If Access doesn't do it automatically, join the city codes fields by
> dragging and dropping one on top of the other.
> Drag and drop all the fields that you wish to see in the order that you want
> to see them on the grid below.
> Run the query. If you like the results, save it.
> Jerry Whittle, Microsoft Access MVP
> Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
> "Dan" wrote:
> > Normally I would just dump this into excel, but the file that I am dealing
> > with has over 1.5 million rows so excel can't stomach it. Here is what I
> > have done. I have one table (MAIN) that is my main table. It contains all
> > the raw data. I need to convert a city code to a city name. I have another
> > table (CITY) with the conversions from city code to city name. Both tables
> > contain all the city codes. All I want to do is put the city names into my
> > MAIN table next to their corresponding city code (there are about 4000
> > different cities). I have related the tables relating the city code and
> > tried making a query but I am lost. What do I need to do.
> > Thanks,