Convert Numbers in Table to Words in ListBox

[theUN4GVEN]

I have a listbox on a form that is used for my own search. The user types in information they are looking for and a list of Invoices shows up in the list box. The listbox is bound to a query that pulls multiple fields from a table (ie. Firstname, Lastname, Invoice Number, etc).

One of these fields is a number field that holds a number from 1 to 12 corresponding to the specific folder each invoice is in.

I would like to know how to convert this number to the specific folder name in the listbox. An example would be:

My listbox holds:

Ed Harris ASC1023 10
Steve Jobs ASC1024 3
Vick Trench ASC1256 5


I would like it to display:

Ed Harris ASC1023 New
Steve Jobs ASC1024 3 Waiting
Vick Trench ASC1256 5 Done

I am not sure if this can be done directly in the query that pulls the information from the table or not.

Any help would be greatly appreciated.

Thanks,
Tom

 

[gol4]

See the choose or switch functions in access help as one possible solution.

 

[matethreat]

You could just have a text box that displays New, or Waiting...etc that is dependant on the number select in the list box.

 

[matethreat]

Or if you have another table with the description of what each of those numbers represent. Then in the query for the list box add the field from that table with the description, and change the column width of the number to zero.