Query help

[jwillis07]

Hi all,

I'm looking for some help with my query problem. Have attached a JPEG of the design view...

The query itself is working fine but I've come across a problem I don't know how to solve. I would like for the column "Priority_Work" to populate with '00. H&S', if the column "H___S" is populated with 'Yes'. If the "H___S" column is not equal to yes then pull the "Priority_Work" as intended.

Hopefully that makes sense and apologies for describing in Layman's terms but am a bit of an access noob but profficient in Excel where I could do this no problem.



Any help greatly appreciated.

Jason

[jwillis07]

Managed to find out how to do it courtesy of a YouTube video, for anyone else interested... I made a new column following "Priority_Work" and put the following into the 'Field' cell...

Priortity_Work2: IIf([H___S]="Yes","00. H&S",[Work_Package])