I have a report in access that has a field called Name. This field is from a query. It's concatenated of the lastname and firstname fields. [ lastname ] &"' "&[firstname] some rows have no name so it printed a comma on my report. How can I remove them?
I appreciate your help.