crosstab query not working Help!

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

Im at my wits end. I have a crosstab query and there is a
field which i have a select case function in a module see
below
function UndDispositions(cde)
Select Case cde
Case Is = 1
UndDispositions = "Loans Approved"
Case Is = 2
UndDispositions = "Loans Pended"
Case Is = 3
UndDispositions = "Loans Rejected"
Case Is = 4
UndDispositions = "Loans Returned"
Case Is = 5
UndDispositions = "Loans Called"
End Select
End Function

i just added case 5 but it wont show up in my query
anyone know why i have data out there ?
 
You should really have a small lookup table that has the code and the
disposition. This would automatically be maintained in data rather than
coded in expressions.

That said, I assume these are used as column headings. Check the Column
Headings property to make sure you have "Loans Called".

Also, a simple expression that would do the same is:
ColHead: "Loans " & Choose([cde],"Approved", "Pended", " Rejected",
"Returned", "Called")
 
Back
Top