The old "IIF"

I am trying to return several value in and IF in a query statement.
The generic is as follows...

=IIf([Forms]![frmParticipantsMain]![NoOfParticipants]=10,Between 1 and
10,"")

Can anyone help with the "Between" part. I realise that it will not
work in the current form but is there someway I can return the records
between 1 and 10. TIA

On Wed, 07 Nov 2007 17:21:19 -0800, Chesne <ashfield@paradise.net.nz>
wrote:

You may want to check out the Choose function.
-Tom.