Access Form

[Sub_Diver]

Trying to create a form in Access from table data with no spaces.

I.E. I would like a table such as (example):

| Topics | Books | Records | Pages |

to come out in a report as:

TopicsBooksRecordsPages

No spacing between, and if the data is varied in sizes, it will still "collapse" that field to allow NO spacing.

What I'm getting is:

Topics Books Records Pages
(Spacing depends on size of info in that column)

Any Ideas?

Thnx

 

[Philem]

Hullo. Off the top of my head, I'd say you want to concantenate the fields into one glued one for the report. There are several concat functions out there. Try www.mvps.org/access for a good one.

HTH

P

 

[Sub_Diver]

Thanks Much!

Exactly what I needed..