Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Reading back names instead of numbers

Status
Not open for further replies.
samusa

samusa

Programmer
Jan 1, 2001
107
US
Hi,
I have a column in a table that uses 1-9 to represent names and these names are saved in another table. I want to get names instead of numbers when I execute a query. Can anyone help me out?Thanks!

Sam
 
Sort by date Sort by votes
You will have to join to your table with the names on the number (assuming that the name table also has the number in it).
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

serino
  • Locked
  • Question
Find a number between two sets of numbers. 1
Replies
2
Views
478
serino
serino
JimStrand
  • Locked
  • Question
Crosstab query - returning 1 record per week instead of 1 record
Replies
1
Views
274
JimStrand
JimStrand
sal21
  • Locked
  • Question
is date in range of two fileds?
Replies
1
Views
111
Andrzejek
Andrzejek
SoLost1
  • Locked
  • Question
Please Help for Passing Multiple Select ListBox Values as Parameter for WHERE IN clause of Query
Replies
3
Views
143
dhookom
dhookom
supportsvc
  • Locked
  • Question
How to limit the number of records based on the quantity in a field? 1
Replies
8
Views
198
supportsvc
supportsvc

Part and Inventory Search

Sponsor

Back
Top