Need help with trying to set criteria to pull data regardless of the position in the field

[Nuby]

Not sure if that's quite right... these are codes related to claims... Claim 12345667 may have HE:N684, CO:185 error codes; while claim21365433 may have CO:185, HE:N684.. there counting result will be 2, since it the same error. Not sure if that helps.

[John_G]

Can I jump in with a couple of questions to clarify -

Is each list of error codes contained in a single text field in the table? So, when you say " Claim 12345667 may have HE:N684, CO:185 error codes;", is that list just in a character string in a table field?

Secondly, when you search, are you just looking for the number (or a list) of records (claims) that have a specific error code?

The solution to your problem might be easy, depending on your answers.

[Bulzie]

I think she would need to do a VBA pre-process to maybe create an error key and then use that to compare or count if multiple claims had the same error codes? If you have a table that has the error codes with a unique ID number, maybe for each record, scroll through all the error codes using like to see if they are in the field, then concatenate the ID into a new error key field. Once that is done group and count the error keys maybe?

Or maybe create a temp table and use Mid, Instr, etc. to get each error code in the record and write to the temp table along with the Claim number. Then can sort that and concatenate the codes for a key maybe.

Or there is a simple solution I am not seeing

[Micron]

John and I (me post 15) have asked the same question. I think the OP has to provide the answers rather than us continuing to speculate.