Ray- Maybe I'm missing something, but the "From" data looks exactly like the "To" data, so I don't understand your problem.
John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of raysgoogle Sent: Friday, December 02, 2005 6:51 AM To: [email protected] Subject: [ms_access] Something probably pretty basic? I have a table with sequences of numbers that are essentially the same except for the leading digits. The idea is a "10" indicates a case and the "00" indicates an item number. I have to create an XLS file with the two numbers in individual columns instead of rows and tack on the descripiton. Essentially like this: UPC Item Case Desc 05555 0005555 1005555 Hotdogs 02345 0002345 1002345 Hamburgers To: UPC Item Code Case Code Description 05555 0005555 1005555 Hot dogs 02345 0002345 1002345 Hamburgers and so forth. For some reason this is just baffling me. I know it's probably really simple, but I just don't get it. Can anyone help? Thanks. Ray. Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/KIlPFB/vlQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
