Change value in field if value in another field is equal to "x"

[fipp]

I have a query and I am calculating a field. I would like that field to be
equal to [group] unless the value of [status]="injured" in this case I would
like the value of [status] to be input re "injured".

 

[KARL DEWEY]

You are using double negatives. Revising you statements I get that if Status
Is Not Equal to "Injured" then the output is to be Group.
What I do not get is what the output is to be if Status Is Equal to "Injured".

IIF([status]="injured", ??? ,[group])

 

[Jeff Boyce]

I'm sure that your description makes good sense when you're looking at your
data ... but we aren't.

Could you post a copy of the SQL statement for that query?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[fipp]

Perfect! That is exactly what I wanted. Thank you

 

[KARL DEWEY]

Try this --
[Forms]![frm_Search]![Manufacturer] Or [Forms]![frm_Search]![Manufacturer]
Is Null

 

[KARL DEWEY]

Wrong thread --

Try this --
[Forms]![frm_Search]![Manufacturer] Or [Forms]![frm_Search]![Manufacturer]
Is Null

I have a query and I am calculating a field. I would like that field to be
equal to [group] unless the value of [status]="injured" in this case I would
like the value of [status] to be input re "injured".

 

[fipp]

IIF([status]="injured", [status],[group])

 

[Jeff Boyce]

Where are you trying to do this? In a query?

Please post the SQL statement of the query...

Regards

Jeff Boyce
Microsoft Office/Access MVP