Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 19th, 2004, 02:02 PM
Friend of Wrox
 
Join Date: Aug 2004
Posts: 159
Thanks: 0
Thanked 0 Times in 0 Posts
Default Access Tables

Help ple!
I have tb1 in an access db and I want to transpose the data in tb1 to tb2 so that some of the data in tb1 becomes fields in tb2 and
some fields in tb1 become data in tb2. Both tables are in the same access db. I would appreciate any help.Tks u anyway.

 
Old August 19th, 2004, 03:04 PM
Friend of Wrox
 
Join Date: Nov 2003
Posts: 625
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to jemacc
Default

You can create a make table query and map the required fields data to the new table.

 
Old August 20th, 2004, 11:30 AM
Friend of Wrox
 
Join Date: Aug 2004
Posts: 159
Thanks: 0
Thanked 0 Times in 0 Posts
Default

To jemacc thank for the attention.
Let me explain the problem in detail so u can see if the solution is to make table qry and map the required fields to the new table.
Tb1 has FieldO with records 1,2,3,4,...and I want tb2 with Column0 = record 1 from Field0, Column1 = record 2 from Field0, Column3 = record 3 ...,and so on.
The records in tb2 Column0 = record 1 will come from tb1 Field1 as first row for example, tb1 Field2 as second row, tb1 Field3 as third row,..., and so on.
As a matter of fact tb1 in my case is a qry, but to make it simple think of it as a table. Tks u anyway sincerely for your support.

 
Old August 21st, 2004, 08:32 AM
Friend of Wrox
 
Join Date: Aug 2004
Posts: 159
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I have posted a new "help ple" where the problem is better explained. So please any help should be on the new posting.Tks.






Similar Threads
Thread Thread Starter Forum Replies Last Post
Word tables to access hayk_yer Access VBA 1 June 26th, 2007 10:49 AM
How to Access Ms-Access WorkGroup tables using VB kishoremf BOOK: Professional Crystal Reports for VS.NET 1 April 29th, 2007 02:05 AM
creating tables within tables in access??? carswelljr Access 3 August 23rd, 2006 01:21 PM
Using lookup tables in Access JohnD Access 4 September 18th, 2004 05:39 AM
Access Linked Tables StephenDID Access ASP 6 October 6th, 2003 10:08 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.