Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2010
    Posts
    2

    Post Unanswered: merge multiple entries in table

    Hi,

    Sorry - I'm relatively inexperienced with Access, this is my last resort after scouring forums (fora?) and the web

    I have a large number of items (plants) in an Access 2002 database, and need to produce a data sheet for each, pulling information from several tables. My plan is to create the data sheet using Word and mailmerge.

    I have a query that pulls data from several tables. The problem is that each plant can have, say, two different scientific names (one old, one current), can be supplied in three different growth media etc., so for one plant there can be multiple rows in my query result.

    When I use this query to mailmerge, of course I get one merged document per permutation, rather than one per plant that lists all the linked scientific names/growth media etc.

    Does this make sense?

    I need to know if I can merge the records in my query result to just have one record per plant.

    Many thanks for any help. I'm willing to learn how to do this, but don't really know where to start.

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    You should know in a minute or so if this is describing the same requirement. I think so...
    http://www.dbforums.com/microsoft-ac...-database.html

  3. #3
    Join Date
    Jul 2010
    Posts
    2
    Yes - that looks like just what I'm after, I'll have a good read. Thank you!

Posting Permissions

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