data transform??

=?Utf-8?B?YXJyYW4xMTgw?=

Guest

Posts: n/a

25th Jan 2006

I have imported data that comes with headings:

AUD
01/02/06 data info
02/02/06 data info

USD
01/02/06 data info

the AUD heading occurs in the same column as the date. I am trying to
manipulate the data into something like this:
01/02/06 data info AUD
02/02/06 data info AUD
01/02/06 data info USD

the imported data has a autonumber as a primary key (ckey field)

any advice on how to do this greatly appreciated
thx

« Repainting a Form | Functions »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

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 Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Transform Data in a table	Chuck W	Microsoft Access	1	16th Dec 2009 08:48 PM
transform data	Samuel	Microsoft Access VBA Modules	5	4th Oct 2004 12:32 PM
transform data in excel	Vincent Yang	Microsoft Excel Discussion	1	28th Jan 2004 01:51 PM
how to transform data from 1 mdb to another automatically?	Jason Shohet	Microsoft Access External Data	3	28th Aug 2003 04:23 PM
transform data to string (or something like that (-: )	Wouter	Microsoft Access VBA Modules	2	30th Jul 2003 06:56 PM