Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2011
    Posts
    1

    Unanswered: A newbie query query

    First post so be gentle…

    I have a pretty basic dbase in Access that facilitates linking of various selections from one table with the names in another. I am having trouble formatting my query to enable me to merge it with Word in a form letter.

    I have three main tables, main, names, selections. Using a form and sub-form, a user can select one name and associate this with a number of selections from the second table (selections_tbl) and these are stored in the Main_tbl. I use a select query to pull names and the selections they have made. The query has one line for each name with the selection, such that there the same name appears multiple times with each different selection.
    EG:
    Smith - Bread
    Smith - Cereal
    Smith - Milk
    Jones – Bread
    James – Milk

    What I would like to output is:
    Smith - Bread, Cereal, Milk
    Jones – Bread
    James – Milk

    Any ideas how I can achieve this?
    Cheers
    Ian

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6

Posting Permissions

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