 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / December 2005Duplicating Data in 2nd column of report
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? Did you create your columns in Page Setup?  SignatureDuane Hookom MS Access MVP -- > 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 [quoted text clipped - 18 lines] > > Can what I'm trying to accomplish be done in Access? Yes I did and choose 4 columns with a layout of Down then Across. > Did you create your columns in Page Setup? > [quoted text clipped - 20 lines] > > > > 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? SignatureDuane Hookom MS Access MVP > Yes I did and choose 4 columns with a layout of Down then Across. > [quoted text clipped - 23 lines] >> > >> > Can what I'm trying to accomplish be done in Access? See below: > If you look at the detail section of your report, do you only see one copy > of each control? 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.) > If you look at the datasheet view of the report's record source, do you see > any duplicates? No > 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? Yes > > Yes I did and choose 4 columns with a layout of Down then Across. > > [quoted text clipped - 23 lines] > >> > > >> > Can what I'm trying to accomplish be done in Access? 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. SignatureDuane Hookom MS Access MVP -- > See below: > [quoted text clipped - 47 lines] >> >> > >> >> > Can what I'm trying to accomplish be done in Access? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.