The old "IIF"

#1 November 8th, 2007, 01:25 AM

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

#2 November 8th, 2007, 02:15 AM

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.

Quote:

>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

The old "IIF"

re: The old "IIF"

/bytes/development

/bytes/it

/bytes/about