Criteria in a query

[jon]

Hi
In a query I am using the following code
=IIf([Forms]![Form1]![Frame14]=2,True,)
but what I need is if it is not = 2 then true or false can be present


Thanks

Jon

 

[Jeanette Cunningham]

jon,

=IIf([Forms]![Form1]![Frame14]=2,True,False)
If the above is the control source for a text box, it
will give true if frame14 = 2, and false if it doesn't in the textbox.

Do you want to set the row source for a combo?
Do you want to allow a user to type true or false in a textbox?
Are you trying to do something else?

Jeanette Cunningham

 

[jon]

Hi Jeanette
sorted
thanks

Jon

jon,

=IIf([Forms]![Form1]![Frame14]=2,True,False)
If the above is the control source for a text box, it
will give true if frame14 = 2, and false if it doesn't in the textbox.

Do you want to set the row source for a combo?
Do you want to allow a user to type true or false in a textbox?
Are you trying to do something else?

Jeanette Cunningham

Hi
In a query I am using the following code
=IIf([Forms]![Form1]![Frame14]=2,True,)
but what I need is if it is not = 2 then true or false can be present


Thanks

Jon

 

[Rogerio Bourbon de Alvear]

Roger Bourbon of Alvear

Welcome Princess

Hi Jeanette
sorted
thanks

Jon

jon,

=IIf([Forms]![Form1]![Frame14]=2,True,False)
If the above is the control source for a text box, it
will give true if frame14 = 2, and false if it doesn't in the textbox.

Do you want to set the row source for a combo?
Do you want to allow a user to type true or false in a textbox?
Are you trying to do something else?

Jeanette Cunningham

Hi
In a query I am using the following code
=IIf([Forms]![Form1]![Frame14]=2,True,)
but what I need is if it is not = 2 then true or false can be present


Thanks

Jon