Results 1 to 3 of 3
  1. 09-23-2009, 01:32 PM #1
    Petefured
    Petefured is offline Novice
    Windows XP Access 2000
    Join Date
    Oct 2008
    Posts
    16

    How to write field values next to each other?

    Dear All,

    I am attaching a sample database, it contains the "before" table and the "after" table that I would like to create either with the help of SQL or VBA
    The point would be to write field values next to each other separated by a semicolon grouped by another field

    Could you please advise?



    Many thanks in advance!
    Reply With Quote Reply With Quote
  2. 09-23-2009, 02:37 PM #2
    RuralGuy's Avatar
    RuralGuy
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,917
    How about showing us some sample data and what the results would look like?
    Reply With Quote Reply With Quote
  3. 09-23-2009, 02:39 PM #3
    Petefured
    Petefured is offline Novice
    Windows XP Access 2000
    Join Date
    Oct 2008
    Posts
    16
    That is in the attachment!
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. ADO.Recordset - Write
    By Marvin in forum Programming
    Replies: 0
    Last Post: 07-17-2009, 07:56 AM
  2. Query multiple values in a field
    By JAYgarti in forum Access
    Replies: 0
    Last Post: 07-09-2009, 09:52 AM
  3. write a query how to???
    By flamingo in forum Queries
    Replies: 0
    Last Post: 01-13-2009, 03:57 AM
  4. clear field values
    By surrendertoo in forum Queries
    Replies: 0
    Last Post: 02-23-2008, 10:57 PM
  5. using a combo to pull up multiple values in the same field
    By ronandamanda114 in forum Forms
    Replies: 0
    Last Post: 12-19-2006, 09:44 PM

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