help with merge field

[edp1959]

This is a two part question:

First
I have multiple fields (as many as 20) that I would like to merge into one. Is there a cleaner way to do this in code or a query other than =[f1] & [f2] & [f3] ............?

Second
If any of these fields are blank I want them to represent a space in the merged field. How do I do this?

 

[Pat Hartman]

There is no easier way to concatenate fields. You can use the Nz() function to handle nulls.

=Nz([f1], " ") & Nz([f2], " ") & Nz([f3], " ")

 

[edp1959]

Help with merge field

The NZ() function worked great. Thanks for the help.