Hi,
I have a query with multiple fields, Three of those fields are named "FirstName","Condition" and "Status". The condition field can be one the following, either "Working","Under Maintenance" or "Damage" and for the status, it's either "Availbale, Unavailable or Assigned".
If the condition is set to under maintenance then the status should switch to Unavailable, the same goes if the condition is set to damaged. however if the firstname is populated then the condition must switch to "Working" and and the status should also be set to "Assigned"
The code below is only my guess and I know it will not work.
I have a query with multiple fields, Three of those fields are named "FirstName","Condition" and "Status". The condition field can be one the following, either "Working","Under Maintenance" or "Damage" and for the status, it's either "Availbale, Unavailable or Assigned".
If the condition is set to under maintenance then the status should switch to Unavailable, the same goes if the condition is set to damaged. however if the firstname is populated then the condition must switch to "Working" and and the status should also be set to "Assigned"
The code below is only my guess and I know it will not work.
Code:
Status: IIf(IsNull([FirstName],"Available","Unavailable","Assigned" and [Condition]=Damaged),"Unavailable","Available")