Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Nov 2004
    Location
    Lexington Park, Maryland, USA
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Query Question (Access 2000)

    I have a table with fields: Attendee1, Attendee2, Attendee3, and Attendee4. I need to generate a report having the all attendees in a single column. For example:

    Attendee1 (Record1)
    Attendee2 (Record1)
    Attendee3 (Record1)
    Attendee4 (Record1)
    Attendee1 (Record2)
    Attendee2 (Record2)
    Attendee1 (Record3)

    How do I go about doing this. I would prefer it be done with some sort of query.

    Thanks
    Mike

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

    Re: Query Question (Access 2000)

    Your data structure is far from ideal. It would be better to have a separate table linked to the main table with a record for each attendee. The report you want would then be easy peasy.

    There's a free example of how to convert the structure on Roger's Access Library: Normalize Denormalize.

  3. #3
    2 Star Lounger
    Join Date
    Nov 2004
    Location
    Lexington Park, Maryland, USA
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Query Question (Access 2000)

    I understand the structure is far from ideal. I would love to convert it. However , I did not create this database and was asked to do this little bit of coding along with a few other things. It was put together pretty badly and I do not have the time to rework it. It works fine the way it is. I just need this one function to work. I got the other stuff fine.

    Mike

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

    Re: Query Question (Access 2000)

    You could use the Concat function that is attached to <post#=301393>post 301393</post#>. You must copy that function into a module, you can then use it in a query or in your report.

Posting Permissions

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