Change the names of Displayed Values

[Ice Rhino]

I have a query that looks through a table and shows me any calls that have a status of either 'O' 'or 'C'. What I would like to have in the query result is the O or C replaced with the words Open or Closed. Then when my count will make alot more sense rather than having O 29 etc.

I have had a look through the forums on the net and I am convinced this question has been asked before, but I am struggling to find the key word to search for

Kindest Regards

 

[KenHigg]

You could try something like this: Link

 

[Ice Rhino]

I have seen the attachment, thanks, I am trying to work out how I would translate that and use that in a scenario where I have O or C

Regards from the thick one

 

[KenHigg]

MyStatus: iif([Status] = "O", "Open", "Closed")

???

 

[Mile-O]

Private Function Convert(ByVal strText As String) As String
    Select Case strText
        Case Is = "O"
            Convert = "Open"
        Case Is = "C"
            Convert = "Closed"
        Case Is = "Open"
            Convert = "O"
        Case Is = "Closed"
            Convert = "C"
        Case Else
            Convert = vbNullString
    End Select
End FunctionSub

 

[Ice Rhino]

Excellent, my thanks to you both, problem resolved now

Case Closed

Kindest Regards