If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Still confused on relationship queries and similating a vlookup
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, |
#2
|
|||
|
|||
Still confused on relationship queries and similating a vlookup
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 query. 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, |
#3
|
|||
|
|||
Still confused on relationship queries and similating a vlookup
On Thu, 4 Mar 2010 09:16:03 -0800, 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, Please see my reply to your earlier message. -- John W. Vinson [MVP] |
#4
|
|||
|
|||
Still confused on relationship queries and similating a vlooku
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 query. 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, |
Thread Tools | |
Display Modes | |
|
|