Make table Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Access 97. I have a make table query that gets it's data from three other tables to make the new one. One of the fields is a 6 digit number, the first two digits represent a facility ID. In the new table I need to replace the 6 digit number with a letter that represents the facility ID, i.e., if I had the number 123456 the 12 is the facility and based on this number I need to change it to an 'A'. Any suggestions would be appreciated.
 
I suggest you create a table that will hold your
conversion information. Two fields - one for the letter
and the other for the corresponding number reference.
In addition, you can create a query that will only show
the first two numbers of the 6 number sequence along with
your other data. Then take that query and the conversion
table along with your other tables and run the make table
query. You can use the Len function to return just the
first to digits in that id field. Good luck.

-----Original Message-----
I am using Access 97. I have a make table query that
Click to expand...
gets it's data from three other tables to make the new
one. One of the fields is a 6 digit number, the first two
digits represent a facility ID. In the new table I need
to replace the 6 digit number with a letter that
represents the facility ID, i.e., if I had the number
123456 the 12 is the facility and based on this number I
need to change it to an 'A'. Any suggestions would be
appreciated.
 
Back
Top