Search results

I have the following quite long access query. It works fine but I want to be able to substitute [ItemDetails]![US_Cost] with either [ItemDetails]![US_Cost] OR [ItemDetails]![NEW_US_Cost] depending on whether [MyOtherTable]![SomeField] = 0 or 1 where this is the 1st record in the table...