Databinding form

aleks1429

Registered User.
Local time
Today, 14:51
Joined
Apr 13, 2004
Messages
12
I am new to MS Access, I don't even know if this is possible, but I really want to know. Anyway, I have a table that I have bounded to a form.

The table is a reference table. It has about 5 to 10 values.

If I bind the table to the report. I get something like this:

1
2
3
4
5

Instead of creating new row for each field, I would like to have them all in one row.
Like this:

1 2 3 4 5 6

How can I achieve this?
 
You could concatenate the fields in the report into one field.

=[Field1] & ", " & [Field2] & ", " & [Field3] & ", " & [Field4] & ", " & [Field5]
 

Users who are viewing this thread

Back
Top Bottom