I am concatenating 2 values in a MS Access Report: "Method" and "Experiment" and they are to be separated by a comma (,).
I have figured out how to concatenate succesfully when the second value is missing (Experiment), but I am struggling to omit a blank space and comma if the first value ("Method") is missing.
The code I am using is:
=([Method] & (", "+[Experiment]))
- Harvard, Mixed sequence