How to show numeric by S, M and L?

[Guest]

Hi,

What shall I type in Access query field if I whant to show numerical values
(=hours) by characters S, M and L?
I mean if the source field values are <=7.5 hours how could character S is
shown in this field (and >7.5 - 37.5 hours shoud be shown M and >37.5 hours
L)?

Thanks a lot...

 

[[MVP] S.Clark]

Maybe Switch can help. Here's the example from the Help file

Function MatchUp (CityName As String)
Matchup = Switch(CityName = "London", "English", CityName _
= "Rome", "Italian", CityName = "Paris", "French")
End Function
-- Steve Clark, Access MVPFMS,
Inchttp://www.fmsinc.com/consultingProfessional Access Database Repair*FREE*
Access Tips: http://www.fmsinc.com/free/tips.html