Duplicating Data in 2nd column of report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've created a report with a query. Everything comes in fine except the
2nd column of my report comes out with the same data as in the first column.
How can I get it so it continues with the next page data.

For ex. This is what it was doing:

ID # Name
1001 Jane Doe
2001 King James
Saveral more lines down the page on several pages.

Trying to save paper I thought I could place this in 2 columns

ID # Name ID # Name
1001 Jane Doe 2001 King James

But it's not doing this. It's doing this:

1001 Jane Doe 1001 Jane Doe


Can what I'm trying to accomplish be done in Access?
 
If you look at the detail section of your report, do you only see one copy
of each control?
If you look at the datasheet view of the report's record source, do you see
any duplicates?
Place a text box in your report Header Section:
Control Source: =Count(*)
Does this count match the number of records you see your report's record
source datasheet?
 
See below:

Duane Hookom said:
If you look at the detail section of your report, do you only see one copy
of each control?
Click to expand...

Yes (But I want to create another column with the same header (Controls)
but the data to continue down the 2nd column instead of going to the next
page.)
 
I'm a little confused since you mention both
"Yes I did and choose 4 columns with a layout of Down then Across"
and then
"I thought I could place this in 2 columns"
You might want to start over a new report using the Label wizard and label
type that matches the number of columns that you want on your page.
 
Back
Top