Microsoft Access Forums

Go Back   Microsoft Access Forums > Access Forums > Programming

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 09-23-2009, 11:32 AM
Petefured Petefured is offline Windows XP Access 2000 (version 9.0)
Novice
 
Join Date: Oct 2008
Posts: 14
Petefured is on a distinguished road
Default 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!
Attached Files
File Type: zip Database1.zip (9.9 KB, 1 views)
Reply With Quote
  #2  
Old 09-23-2009, 12:37 PM
RuralGuy's Avatar
RuralGuy RuralGuy is offline Windows 7 Access 2007 (version 12.0)
Super Moderator
 
Join Date: Mar 2007
Location: 8300' in the Colorado Rocky Mountains
Posts: 3,848
RuralGuy will become famous soon enoughRuralGuy will become famous soon enough
Default

How about showing us some sample data and what the results would look like?
__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07
If your issue is resolved...follow this link for directions on how to use the Solved thread tool!
Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"
Reply With Quote
  #3  
Old 09-23-2009, 12:39 PM
Petefured Petefured is offline Windows XP Access 2000 (version 9.0)
Novice
 
Join Date: Oct 2008
Posts: 14
Petefured is on a distinguished road
Default

That is in the attachment!
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
ADO.Recordset - Write Marvin Programming 0 07-17-2009 05:56 AM
Query multiple values in a field JAYgarti Access 0 07-09-2009 07:52 AM
write a query how to??? flamingo Queries 0 01-13-2009 12:57 AM
clear field values surrendertoo Queries 0 02-23-2008 07:57 PM
using a combo to pull up multiple values in the same field ronandamanda114 Forms 0 12-19-2006 06:44 PM


All times are GMT -8. The time now is 08:14 PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.3.2 ©2009, Crawlability, Inc.