switch calc

[Guest]

My switch calc doesn't work:
People:SWITCH ( PeopleID = 1, 'Party', PeopleID = 2, 'Attorney', PeopleID =
3, 'Insurance',TRUE, CHR(0) )

If the ID field is 1, I want the text Party. If the ID field is 2 I want
the work Attorney.
If it is 3 I want Insurance on the line in the report.

Do you know why?
tia,

 

[Guest]

Hi Janis,

I just plugged your expression into a new query and it works fine for me,
after I changed the field name to match one in my database. So, you might
verify that the
PeopleID field is numeric (that's what your formula suggests).


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Guest]

PS. Make sure that you do not have any references marked as MISSING, since
you are calling the VBA Switch function. Here are two excellent articles on
the topic of missing references and the problems they can cause:

Solving Problems with Library References (Allen Browne)
http://allenbrowne.com/ser-38.html

Access Reference Problems (Doug Steele)
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html