Multi-column report - duplicate data

[czack]

Major bonehead question so please hang in there - I have a report in two columns (my own version of my very simple address book) and I'm getting repeat data on the second column (new data on the next section down). I've already done the multi column, across then down thing and it's still printing duplicate data. I've been out of the programming loop for some time and I used to know how to fix this (but lost that report with a system crash) and for the life of me cannot get this duplicate data to go away. Please help - mommy brain really sucks sometimes.

CZACK

 

[dhookom]

The duplicates are probably coming from your report's recordsource query. View its datasheet and possibly make the query into a totals query.

Duane
MS Access MVP

 

[czack]

Okay, since I've found someone, I will go into a little more detail. I'm just making a report off of my very simple address table. So I don't have duplicate data there. Should I be creating this off of a query instead? Seems like more work than just using the data in the table. I've just created a report to make a nice looking printout of the table - name, address, etc. I wanted it to be two column so that I can save paper, two people at a time, getting about 6 people per page. This time I'm getting the same name on the left and right column but then a new name on the next row of info, left and right. So I end up with 6 spots, but only 3 names. I made this report once before and figured out how to turn off the duplication but I can't remember and unfortunately lost that report (poor backup practices that have since been remedied!). I feel like a total dunce asking for help but if feels like I should have some sort of "next record" feature like you have when you're doing a label merge in Word, but I can't figure out where to put it. I can't find anything online and the Help documentation doesn't have anything either.

Can you help me out there now that you know some more details? This is just a simple project for a non-profit that I'm part of - have been out of the real working world for far too long, brain is now mush!

Czack

 

[dhookom]

It sounds like you have two copies of your controls in the detail section of the report. You should only create the report with one copy of the controls and make the report width about 4". Then select File->Page Setup and set the number of columns to 2.

BTW: I always base reports on queries or SQL statements.

Duane
MS Access MVP

 

[czack]

Thanks! I did figure that out - I went into the column area and actually made them more narrow and only put one sent of controls in the design view. Works like a charm.

Thanks again!