Criteria in a query

  • Thread starter Thread starter jon
  • Start date Start date
J

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
 
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 Jeanette
sorted
thanks

Jon

Jeanette Cunningham said:
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 said:
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
Click to expand...
Click to expand...
 
Roger Bourbon of Alvear

Welcome Princess

jon said:
Hi Jeanette
sorted
thanks

Jon

Jeanette Cunningham said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top