I have a table has the following layout and about total of 3600
records:
ID# group dwgs spec
1 Arc A-A-0001 01400
1 Mec A-B-0003 01401
1 Fpn A-A-0002 05012
1 Elc A-C-0002 07801
2 Arc A-A-0003 01404
2 Civ A-C-0008 01441
3 Plu A-F-0005 09000
3 Ins A-I-0001 06000
I have to get that Table layout change into the following form, how to
use query/queries to handle it?
ID# group
dwgs spec
1 Arc, Mec, Fpn, Elc A-A-0001, A-B-0003, 01400,
01401,
A-A-0002, A-
C-0002 05012, 07801
2 Arc , Civ A-A-0003 , A-C-0008
01441, 01404
3 Plu , Ins A-F-0005, A-
I-0001 09000, 06000
Help! Thank You!
|
|
0
|
|
|
|
Reply
|
 Fuzuy
|
8/16/2007 1:46:11 PM |
|
On Aug 16, 8:46 am, Fuzuy <huiko...@yahoo.com> wrote:
> I have a table has the following layout and about total of 3600
> records:
>
> ID# group dwgs spec
> 1 Arc A-A-0001 01400
> 1 Mec A-B-0003 01401
> 1 Fpn A-A-0002 05012
> 1 Elc A-C-0002 07801
> 2 Arc A-A-0003 01404
> 2 Civ A-C-0008 01441
> 3 Plu A-F-0005 09000
> 3 Ins A-I-0001 06000
>
> I have to get that Table layout change into the following form, how to
> use query/queries to handle it?
>
> ID# group
> dwgs spec
> 1 Arc, Mec, Fpn, Elc A-A-0001, A-B-0003, 01400,
> 01401,
> A-A-0002, A-
> C-0002 05012, 07801
> 2 Arc , Civ A-A-0003 , A-C-0008
> 01441, 01404
> 3 Plu , Ins A-F-0005, A-
> I-0001 09000, 06000
>
> Help! Thank You!
You don't. Use fConcatChild from www.mvps.org/access the code is in
the Modules section.
|
|
|
0
|
|
|
|
Reply
|
pietlinden
|
8/17/2007 12:32:31 AM
|
|
|
1 Replies
355 Views
(page loaded in 0.205 seconds)
Similiar Articles: Auto table name change in Access queries - microsoft.public.access ...Do anyone know how to disable automatic table name change in Accessqueries?Currently, I am testing a set of 30 queries in an Access database andneed t... Automate Changing Table Name in Query - microsoft.public.access ...query to change the layout of a table - microsoft.public.access ... Automate Changing Table Name in Query - microsoft.public.access ..... an Access database (several ... Update Query Changing value to negative - microsoft.public.access ...I am trying to use an update query to change values in a table to negative. Any suggestions. ... One-to-many join query limited to one row per row in the One side ...... event of the report to allow the same report layout to ... one side, with one > row per row in the one side table, without having to actually change the > underlying query ... Can't save pivot table layout - microsoft.public.access ...... and pivot chart layout. I've tried to: - build a query\view and set pivot table... ... Data Field Layout Arrange Excel pivot table data fields horizontally, and change names ... How do I Transfer Data from one table to another - microsoft ...... not identical) headings and different data in each table similar to below. Prices change ... the current price in the same format as the TblPrice layout using a query ... Update Query to Force Field to Uppercase in Table - microsoft ...Add the table you want to update. 3. Change the query type to 'Update Query'. Update Query to Force Field to Uppercase in Table - microsoft ... I want to create an ... Make Query or Linked Table Read Only - microsoft.public.access ...Due to many security, DB, and vendor issues, I do not have an option to change ... Cannot run make-table query - microsoft.public.access When I run a make-table query in ... Adding Date to the table name in a Make Table Query - microsoft ...Adding Date to the table name in a Make Table Query - microsoft ..... FROM tblCO_Order_20; Then use VBA to change the table name to ... in a make table query - microsoft ... Changing header and footer details in queries????? - microsoft ...Inserting table/query headers and footers ... Header/Footer in Publishing Layout - microsoft.public.mac ... How do I change the header or footer to print an Access table ... query to change the layout of a table DataBaseI have a table has the following layout and about total of 3600 records: ID# group dwgs spec 1 Arc A-A-0001 Microsoft Access: Change form layout from table to query ...database.itags.org: Microsoft Access question: Change form layout from table to query?, created at:Mon, 26 May 2008 11:04:00 GMT with 926 bytes, last updated: Sunday ... Sorting/filtering a table with a Query to change layout ...Sorting/filtering a table with a Query to change layout. Microsoft Access / VBA Forums on Bytes. MS ACCESS :: Query Change Data In TableNeed Code To Change Data In A Populated Table; Query To Change Data Layout; Extracting Data From Linked Db2 Table Using Access Make Table Query; Replace Data Of A Query With ... How to: Customize the Layout of an Individual Table By Using a ...For more information, see Walkthrough: Customizing Table Layout Using Entity Templates. ... If you created a Web application project (WAP) you must change the namespace in ... 7/26/2012 2:25:03 PM
|
Search |
Post Question |
Groups |
Stream |
About |
Register
16 followers. 