Showing records in colums

  • Thread starter Thread starter Gopher
  • Start date Start date
G

Gopher

Im trying to create a report in access, but I want it to show the
records in colums not in rows.
i.e

Record 1 Record 2 Record 3 Record 4
Field(A) 1 Field(A) 2 Field(A) 3 Field(A) 4
Field(B) 1 Field(B) 2 Field(B) 3 Field(B) 4
Field(C) 1 Field(C) 2 Field(C) 3 Field(C) 4
 
Gopher said:
Im trying to create a report in access, but I want it to show the
records in colums not in rows.
i.e

Record 1 Record 2 Record 3 Record 4
Field(A) 1 Field(A) 2 Field(A) 3 Field(A) 4
Field(B) 1 Field(B) 2 Field(B) 3 Field(B) 4
Field(C) 1 Field(C) 2 Field(C) 3 Field(C) 4


Open your report in design view. Drag the text boxes so
that they are one above the other.

Then select the Columns tab in the File - Page Setup menu
item. Set the number of columns that you want to use. Then
unselect the Same As Detail check box and type the desired
column width. Click OK.

When you are back in your report's design view Save the
report and test it to see how it works.
 
Back
Top