Can I retrieve the value of user-defined type in a query

[bremersj]

Is there a way to retrieve the value of a user-defined type in a query?

Here's the type:

Public Type ClassRank
    Rank As Integer
    ClassCount As Integer
End Type

I have a function with the following excerpt:

Function GetRank(strDOD) as ClassRank
...
GetRank.Rank = intRank
GetRank.ClassCount = intCount
...
End Function

In my query I expected to be able to put the following:

GetRank(strDOD).Rank & " " & GetRank(strDOD).ClassCount

However, Access didn't like the period in .Rank or .ClassCount.

Any easy solutions or should I just write two different function to get 'rank' and 'classcount'?

Thanks for your help!

--Steve

 

[Guus2005]

Adjust your code slightly.

dim udtResult as ClassRank

udtResult = GetRank(strDOD)

udtResult.Rank & " " & udtResult.ClassCount

HTH

 

[bremersj]

Ahh...perfect. Thank you!