Hi all,
I need to combine 4 fields
I used below code
If field 3 and field 4 is blank, i dont want to see the seperator and the same with firled 1 and 2
Please could you advise
I need to combine 4 fields
I used below code
If field 3 and field 4 is blank, i dont want to see the seperator and the same with firled 1 and 2
Please could you advise
Check: [Detailed Inspections TBL]![Limit 1] & " " & [Detailed Inspections TBL]![Unit 1] & " / " & [Detailed Inspections TBL]![Limit 2] & " " & [Detailed Inspections TBL]![Unit 2]