Truncate fields in a report

Hello Everyone:

I am trying to truncate fields in a report. Say you have a number of different names. If you put the fields in the report, they will have white space in them.

First------------------------middle----------------------last.

I had to put the -'s in because it autmatically took them out.

How can I make it so that they come out more like this?

First middle last with no spaces.

Thanks

Art W.

what application are you working in?
what type of fields have you inserted?

Hi Everyone:

I am using MS Access 07, trying to bring text felds together.

Thanks

Art W.

sorry i know nothing about access fields

You can create an Access Query with the information that you need. Within the Query you can combine multiple fields from the table, Such as;

Code:

---

fullname: [First] & [Middle] & [Last]

---

I know you said that you didn't want any spaces or anything, but as an idea you can also include other characters, such as;

Code:

---

fullname: [Last] & ", " & [First] & [Middle]

---

you may also use the Nz function of Access to eliminate any errors due to having a null value in a field, like;

Code:

---

fullname: Nz([First], "") & Nz([Middle], "") & Nz([Last], "")

---