I am trying to return several value in and IF in a query statement.
The generic is as follows...
=IIf([Forms]![frmParticipantsMain]![NoOfParticipants]=10,Bet ween 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
wrote:
You may want to check out the Choose function.
-Tom.
>I am trying to return several value in and IF in a query statement.
>The generic is as follows...
>
>=IIf([Forms]![frmParticipantsMain]![NoOfParticipants]=10,Be tween 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