Search results

That works a treat - thank you so much

It is an expression builder.

Hi Could you help me, i want a query to show one field from one table if that is blank then another field from another table, then if that it blank return " ". Can this be done. I have set up Exp3: Nz([tbl_lead_worker]![Role],[tbl_initial_worker]![Role]," ") but when i run the query get a...

Hi, A basic question i am running a query to export to excel I have three separate fields in one table , for some reason the date fields have been split DATE, MONTH ,YEAR. How do i merge these fields to display DD/MM/YYYY. Many Thanks