if statement

[smason]

hello i am new to if statments so please help

i am trying to indicate in a query records that have been placed by saying
if a record has a placements Id (represented as a number... example -100000 )
then the value i want is YES if not then NO

i have tried the following
=iif(<1([placementid]),[yes],[no])

any ideas

 

[BruceM]

NewField: IIf([PlacementID] < 1,"yes","no")

This would be placed at the top of an empty column in query design view. If
you replace NewField: with an = sign the expression can be used as the
control source of a text box. This asumes that [PlacementID] is a field in
the query's source table, and that "yes" and "no" are the actual words you
want to see. Susbstitute whatever name you choose for NewField.