Results 1 to 10 of 10
  1. 03-02-2011, 07:35 PM #1
    newtoAccess
    newtoAccess is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Nov 2009
    Posts
    226

    Duplication in a report

    I am creating name tags for a convention.
    I have a query that finds all names that have not been printed.
    I created a report to print the name tags in two columns on a 4x3 in cards. (81/2 x11) they look good.
    The problem:
    The query has the correct number of names and other info.
    The report is based on the query.
    When I Print preview the report it appears to have every name in the report duplicated over 6 times. However in the query it only shows up once as they should.
    The name tag report should be 12 pages and now I am up to 6000+ pages. It looks like every time I run the report that it is adding to the previous report. Can this happen?
    Reply With Quote Reply With Quote
  2. 03-03-2011, 05:56 AM #2
    RuralGuy's Avatar
    RuralGuy
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    What is the RecordSource of your Report?
    Reply With Quote Reply With Quote
  3. 03-03-2011, 06:21 AM #3
    newtoAccess
    newtoAccess is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Nov 2009
    Posts
    226
    The Query that has the correct info in it. I also created a new report from scratch and it does the same thing. It duplicates the data several times.
    Reply With Quote Reply With Quote
  4. 03-03-2011, 07:13 AM #4
    RuralGuy's Avatar
    RuralGuy
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Maybe if you could attach your db we could see what is happening.
    Reply With Quote Reply With Quote
  5. 03-03-2011, 07:43 PM #5
    newtoAccess
    newtoAccess is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Nov 2009
    Posts
    226
    It is full of names and private info. I will delete the names and fill with fake info and see if it does the same and will attach it if it fits.
    Reply With Quote Reply With Quote
  6. 03-03-2011, 09:10 PM #6
    newtoAccess
    newtoAccess is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Nov 2009
    Posts
    226

    See attached

    here it is. I hope you can open it. see attached
    Reply With Quote Reply With Quote
  7. 03-03-2011, 09:16 PM #7
    RuralGuy's Avatar
    RuralGuy
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Which form and/or report?
    Reply With Quote Reply With Quote
  8. 03-03-2011, 09:23 PM #8
    RuralGuy's Avatar
    RuralGuy
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Okay, I think I located the form and report. Did you check that this db exhibits the problem?
    Reply With Quote Reply With Quote
  9. 03-04-2011, 05:45 AM #9
    newtoAccess
    newtoAccess is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Nov 2009
    Posts
    226
    Yes, it did just before I attached it. Once you select the print ID's. A new window will be displayed where the user can verify which names to be printed. I selected all (70) and got 6000 pages, If I select 10 I get 6000 Pages. Try selecting none and I got1 page at one time. I did not check none last night. If there are 70 names and 6 id tags on a page there should be only be 12 page not 6000pages. the query that the ID report is using will find 10 names, but the report displayes 6000 pages.
    Reply With Quote Reply With Quote
  10. 03-05-2011, 05:41 AM #10
    newtoAccess
    newtoAccess is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Nov 2009
    Posts
    226
    Is anyone working on my problem?
    Is the problem showing up for you?
    I have build a new report and I have the same problem.
    If I select one name it print 100 times, not once. bad
    If I select 0 names no ID cards are printed. good
    How do I see the code for Reports?
    My query is still good?
    Any suggestions?
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Duplicate a business form in an Access Report (add blank records to a report)
    By thekruser in forum Reports
    Replies: 4
    Last Post: 12-13-2010, 05:33 PM
  2. Query duplication issues
    By MiCCAS in forum Queries
    Replies: 1
    Last Post: 02-18-2010, 11:31 AM
  3. report detail duplication
    By archie in forum Reports
    Replies: 5
    Last Post: 09-17-2009, 08:51 PM
  4. Access Database Duplication problem
    By Tempuser in forum Queries
    Replies: 9
    Last Post: 09-10-2009, 05:53 AM
  5. duplication
    By noidea in forum Access
    Replies: 1
    Last Post: 07-31-2009, 06:22 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Other Forums: Microsoft Office Forums