Change entry query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello

I've inherited a database and am trying to clean it up. My current issue is with the way entry were made.
For instance instead of making multiple entries ( 1 per part number) they previously would on occasion enter multiple part number together. Please not that multiple entries where not always made. The table is a mix and mash of data entries

Exampl
Part Number Descriptio
*****************
11588, 11589, 11590, 11591, 11592, 11593, 11700, 11701, 11702 ZEBRA HEAD FRONT, ZEBRA HEAD BACK, ..

The example above is one entr
Where they simply listed all the entries on one line instead of creating seperate entries

My question is, is there a way of creating a query that will seperate (create a table) the info

I want as a final product
Exampl
Part Number Descriptio
*****************
11588 ZEBRA HEAD FRON
11589 ZEBRA HEAD BAC
11590 ZEBRA HEAD BAS
and so o

Thank you Daniel
 
A single query will not be able to parse this data. Using VBA code, you
could create a routine to do so, but it would be very difficult, as I'm sure
you have about a thousand exceptions to each row of data.

For the most part, you have a lot of hard work in front of you. You may
want to consider simply hiring a temp to re-enter the data properly, as the
current data is probably pretty bad to begin with.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

Daniel P said:
Hello,

I've inherited a database and am trying to clean it up. My current issue
Click to expand...
is with the way entry were made.
For instance instead of making multiple entries ( 1 per part number) they
Click to expand...
previously would on occasion enter multiple part number together. Please
not that multiple entries where not always made. The table is a mix and
mash of data entries.
Example
Part Number Description
******************
11588, 11589, 11590, 11591, 11592, 11593, 11700, 11701, 11702
Click to expand...
ZEBRA HEAD FRONT, ZEBRA HEAD BACK, ...
 
Not what I wanted to here. But thank you for your brutal honesty

Thanks at least now I know what needs to be don

Daniel
 
Back
Top