Search results for query: *

PH, Thanks - making it a standard code module helped but what ultimately got the query to run was taking "Option Compare Database" out of the standard module statement. Thanks for all your help - that's a great approach to busting up comma delimited files. TW

When I eliminate the reference to the table the new message that comes up when I try to run the query is: undefined function 'mysplit' in expression I've searched for this error message on the forum with limited success.

Thanks for all (especially PH) who have helped me thus far on splitting 1 field with 12 numbers separated by semicolons into 12 separate numeric fields. I'll provide an update so others might be able to help me figure this out! Data field is called MEB-lyr, data looks like...

Thanks for all (especially PH) who have helped me thus far on splitting 1 field with 12 numbers separated by semicolons into 12 separate numeric fields. I'll provide an update so others might be able to help me figure this out! Data field is called MEB-lyr, data looks like...

Dryseals, Do you know why I would be getting the error message "Undefined function 'mysplit' in expression"?

Hi PH, Almost there (I think!) - I renamed the mysplit module splitfield but kept the contents the same otherwise. After I put in your code in the query grid when I run the query I get the following message: "Undefined function 'mysplit' in expression" Thanks again for all your help so far -...

Appstaff, Thanks, but it will be a monthly process so I'm hoping to automate the split.

Thanks for your input, PH. This is what I tried so far... I added a module named mysplit with the following code (the option compare database was already there when I opened the module): Option Compare Database Public Function mysplit(str, delim, n) On Error Resume Next mysplit = Split(str...

I'm new to this group and have some experience in Access, but only in writing simple query statements. My problem is that I have a memo data field with 12 values separated by a ";". The data field is called MEB-lyr...