If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Duplicating Data in 2nd column of report
Did you create your columns in Page Setup?
-- Duane Hookom MS Access MVP -- "melwester" wrote in message ... 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? |
#2
|
|||
|
|||
Duplicating Data in 2nd column of report
Yes I did and choose 4 columns with a layout of Down then Across.
"Duane Hookom" wrote: Did you create your columns in Page Setup? -- Duane Hookom MS Access MVP -- "melwester" wrote in message ... 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? |
#3
|
|||
|
|||
Duplicating Data in 2nd column of report
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? -- Duane Hookom MS Access MVP "melwester" wrote in message ... Yes I did and choose 4 columns with a layout of Down then Across. "Duane Hookom" wrote: Did you create your columns in Page Setup? -- Duane Hookom MS Access MVP -- "melwester" wrote in message ... 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? |
#4
|
|||
|
|||
Duplicating Data in 2nd column of report
See below:
"Duane Hookom" wrote: 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 -- Duane Hookom MS Access MVP "melwester" wrote in message ... Yes I did and choose 4 columns with a layout of Down then Across. "Duane Hookom" wrote: Did you create your columns in Page Setup? -- Duane Hookom MS Access MVP -- "melwester" wrote in message ... 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? |
#5
|
|||
|
|||
Duplicating Data in 2nd column of report
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. -- Duane Hookom MS Access MVP -- "melwester" wrote in message ... See below: "Duane Hookom" wrote: 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 -- Duane Hookom MS Access MVP "melwester" wrote in message ... Yes I did and choose 4 columns with a layout of Down then Across. "Duane Hookom" wrote: Did you create your columns in Page Setup? -- Duane Hookom MS Access MVP -- "melwester" wrote in message ... 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? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel Macro to Copy & Paste | [email protected] | Worksheet Functions | 0 | December 1st, 2005 01:56 PM |
Has anyone seen this behaviour? What might it be? | tw | General Discussion | 4 | June 30th, 2005 03:23 PM |
strategy for data entry in multiple tables | LAF | Using Forms | 18 | April 25th, 2005 04:04 AM |
Still Hoping for help with a Query problem | Don Sealer | Using Forms | 15 | November 13th, 2004 06:24 AM |
Countif with 2 or more data ranges in same column | Doug | Worksheet Functions | 1 | July 4th, 2004 08:57 AM |