I have just created a report (membership directory) from my access database. However, I want last name and first name, as well as city and state, all of which are separate fields to be concatenated and separated as follows, for example:
Also, I exported this to word, figuring I'd have to manually edit these items (for 165 records - not something I look forward to), but I got something that is not in the report data or layout. There is a field entitled "Fax:". It shows up in Word as "Company Fax:" I've gone all over my report setup in Access, and I've checked my autocorrect in Word, but I can't find any reason for this.
If I can join those fields in Access, then my word question is moot; but if I can't, then I've got to get rid of the extraneous fieldname info in word.
Finally, I was able to draw a line beneath each record in Access, but that line gets dropped when I export to word. Any way to get it to stay?