I am relatively a new MS Access 2000 user. I am having a problem with the Trim() string.
I have created a table with 25 records and it contains 25 fields. I am trying to unite four (4) fields in a query to create one field in a report. I thought Trim() function would work. I have fields that are empty in some records and I don't know how to eliminate those empty fields. (See example)