Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    May 2002
    Location
    Jerusalem, Israel
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Reports based on Combo Boxes in a Continuous Form (Access 2003)

    In a previous question (Combo Boxes in a Continuous Form (Access 2000 or 2003) <post:=642,846>post 642,846</post:>) I asked about creating a continuous form using combo boxes in a subform. Thanks to your help I have been quite successful and have found many uses for that neat trick throughout a new database that I am currently creating.
    However, now I want to create reports to extract the data that I have put in. I can't figure out how to do this. I created a query that finds the information, but each item is repeated multiple times to accommodate the many entries. For example, if I have reference number 123 and I have selected 3 salespeople for that reference number from the combo boxes, the query gives me three separate records, each with identical information except for the salesperson name, which is different on each record.

    How can I create a report that only gives me the reference number once and each salesperson once etc? Some of my queries will have information extracted from more than one of these combo box subforms, so how do I prevent further duplication of information.

    Thanks for your help,

    JoeK

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Reports based on Combo Boxes in a Continuous Form (Access 2003)

    You could use a subreport for the salespeople.

    Another option is to set the Hide Duplicates property to Yes for text boxes that shouldn't display the same information more than once in a row.

  3. #3
    4 Star Lounger SteveH's Avatar
    Join Date
    Jan 2001
    Location
    Chelsea, Gtr London, United Kingdom
    Posts
    587
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Reports based on Combo Boxes in a Continuous Form (Access 2003)

    It sounds like you need to group your data in the report. It is hard to say without seeing the db but the Grouping and Sorting options within the report design sound appropriate.
    Steve H
    IT Lecturer/Access Developer
    O2K SR3/O2010; Win7Pro

Posting Permissions

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