switch function

[farquar]

I have a ticket description field (ticket_desc) which contains E.g Single, Return

I have an indicator field which can contain a ref number (card_no).

I am using the switch function and I want to say:

if the card_no field is not null then the ticket_desc field should display 'Free', if it is null then it should just display the ticket_desc value.

my code at the moment is this, but it won't accept it:

Switch([card_no=null,tbl_ticket_type.ticket_desc,True,"Free"])

Does the switch command allow you to refer to a field rather than a fixed value ?

I am an oracle developer and SO miss my DECODE facility!!

Cheers

 

[RivetHed]

just have a field with the following
IIF(ISNULL([Card_No]),[Ticket_Desc],"Free&quot

 

[farquar]

Thanks, I failed to mention that I am doing this in an sql query, is this ok ?

 

[RivetHed]

if your using the sql builder within access it should be fine just add in your field name at the end so:
Select IIF(ISNULL([Card_No]),[Ticket_Desc],"Free&quot as FieldName

 

[farquar]

cheers, ta, thank you, merci