Ok, had another play and got it to work using the following, =IIf(Not IsMissing([Heada]),[Heada],IIf(Not IsMissing([Headb]),[Headb],[Headc])) I'm assuming here that heada, headb etc are fields in a table. If so you create a report (I used the wizard) containing Job number and heada, then open the report in design view, right click on heada in the detail section and select properties, paste the above code in the "control source field" on the data tab, rename the text box on the other tab so it's not heada (gets confused between the text box and field name) and it should all be cool.