Creating a report of 2 columns of records

Question

I'm looking for the procedure to create a report of 2 columns of records each containing 2 fields. This should be a simple task but I find no help anywhere. Example:

                  record #1                                                 record #33

                  record #2                                                 record #34

                  record #3                                                 record #35

                     Etc                                                              Etc

Answer 1

What does the table look like? Not completely clear what you want.

You can set columns in Page Layout and set them to go down then across.

Answer 2

The table is one column of records containing 2 fields in a row. I need to create a report so the records form one column on the left side of the print and continue in a second column on the right side. Example:

                  First record here                                                From the bottom of column right

                  Second record here                                            continue records here

                  and so on to the bottom of the page                 and here

                                                                                              and so on to the bottom

Not very complicated but very illusive for me.  Microsoft Office 2013 page 1317 has a Label

report in this form to see my goal. I tried the Mailing Label Wizard but I can't manipulate the fields into the proper position. Some way this must be set up with a "create function" I think.

    Page setup in the Print Window does not do it.

Many Thanks For Your Help.

Chamar

Answer 3

Print Layout sure does do it. Like I said you need to setup columns. Your Detail band should be one row high and the 2 controls should take up less than half the row. Then set up 2 columns that are set to Down then Across. I do it all the time.

Answer 4

I'm sorry Scottgem, but nowhere in my print properties do I see 'Down then Across'. And my Access knowledge may be deficient too as "What/Where is 'Detail Band' and 'Controls'?

So this help I am seeking may need to be more detailed.

     By the way, my printer is a Canon and may have different properties than normal.

Thanks again for your time and knowledge.

ChamarAZ

Answer 5

You need to look at the whole screen. The first screen shot shows a report open in Design mode. There are arrows pointing the the Page Setup tab on Report Design Tools and then the Page Setup dialog (or you can just choose the Columns dialog.

There is another arrow pointing to the Detail band of the report. Controls are objects placed on a report that may or may not be bound to fields in a table. In this case the report is bound to a table of US States and I placed two controls for the state abbreviation and name. Below the Page footer is the Page Layout dialog displaying the Columns tab. Not that I have it set for 2 Columns and the layout for Down then Across. Note, I forgot to change the Column Width, it should be about half the page width.

Following is the results of this setup in Print Preview mode

That is what you asked for, isn't it?