Seperating data within a field for calculation on a form.

[rc51wv]

I have a table that it setup as:

"AutoNumber Key", "Employee ID", "Error ID", "Date" and "Trace Number"

The Error ID field can contain multiple Error codes, always a combination of
one letter and one or two numbers. The code for the form uses an array to
seperate these for display on a form but I need to be able to seperate these
for use in a table.

The first entry in the table for the Error ID field is "E1 E9 E10 E11 E13"
Is there a way to seperate this in a form or a way for the form to call up a
module that I can have code in to seperate these codes in the entry or is it
going to call for a redesign of the table and the way the data is handled?

-Thanks in advance for any replies help.

 

[rc51wv]

Sorry, I meant that I'm trying to seperate the data in the fields for use on
a report. I already have it done in the form, but can I use the same code or
a module to do this in a report, not a form like I originally posted.

Sorry for the confusion.

 

[KARL DEWEY]

I'm trying to seperate the data in the fields for use on a report.
How do you want it separated? Separate fields or separate records?

 

[Marshall Barton]

Sorry, I meant that I'm trying to seperate the data in the fields for use on
a report. I already have it done in the form, but can I use the same code or
a module to do this in a report, not a form like I originally posted.

Sorry for the confusion.

You really should have one value in a table field. Multiple
values such as that will only cause problems. Actually, you
should have the letter and the number in separate fields so
you never have to parse out the number part.

If restructuring your tables would violate your terms of
employment, then whatever you did in the form should also
work in the report. OTOH, the built in VBA function, Split,
should be a big help there. If you do use some code to
unravel the list of values, you can expect more difficulties
in the future.