![]() |
|
|
#1
|
|||
|
|||
|
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! |
|
#2
|
||||
|
||||
|
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" |
|
#3
|
|||
|
|||
|
That is in the attachment!
|
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
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 |