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

  • Thread starter Thread starter fipp
  • Start date Start date
F

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".
 
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])
 
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
 
Try this --
[Forms]![frm_Search]![Manufacturer] Or [Forms]![frm_Search]![Manufacturer]
Is Null
 
Wrong thread --

KARL DEWEY said:
Try this --
[Forms]![frm_Search]![Manufacturer] Or [Forms]![frm_Search]![Manufacturer]
Is Null

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