Search results

I fixed the error by recreating my query. It had something to do with my query - the way I pulled the information. Plog's post urged me to check out the query.

I got it fixed! Thanks for your help!

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...

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.

I have worked with Access for several years. I have not had the need for complex queries until now. I need some help! Thought this might be a good starting place. Lori