=nz([Muni Master]![Address 1], vbNullString) & " " & nz([Muni Master]![Address 2], vbNullString)
The report is sorted on Muni Master - to list the organization name in alpha order with the contact information. Then it is sorted by Last name to list the names of employees of the organization in alpha order. The only two places that I get an error is the Muni Master Address line and Muni Master city and state line. The Muni Master Email works fine.1. Is your report's data source actually Muni Master? Or is Muni Master part of a query and the query is the data source?
2. Did you mistype the table name?
3. Did you mistype the field name(s)?
4. Does Muni Master actually contain those fields?
So please say what fixed it. It could help someone else later, you never know.?I got it fixed! Thanks for your help!
Most important question, what's on the left side of the = sign?This is my expression, very basic: =[Muni Master]![Address 1] & " " & [Muni Master]![Address 2]. Why do I get a #type! error. Both fields are short text.