Select Case and Query Field Values

[Lstclair]

Good morning,

I am trying to use a Public Function to determine the result of a field value in a query.

Select Case notetypeid
Case "1"
fsort = [ValuationProperty].Value
Case "2"
fsort = "Property"
Case Else
fsort = "ValProperty"
End Select
End Function

When I call this in the query I want to retrieve the Value of the field ValuationProperty

How can I do this?

 

[jdraw]

What is the query? What table(s)?
What are you trying to do in simple, plain English? That is, what is the business scenario that this set up is proposed to answer?

 

[pbaldy]

It would more efficient and dynamic to have a table with those values and join to it in the query.