Using strings to filter database

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

Guest

I have a database with two text fields that contain numbers and letters that
correspond to rule citations. I am trying to filter the database by trying to
match the rule citation string in one field (in that field there are no
letters, just numbers separated by a ".") with a string that matches it from
the other text field (in the second field, the rule citation may contain
letters along with numbers and, many times, there is more than one citation
listed). I know this must be simple, but I can't come up with the answer. I
desperately need advice as my database contains 147K records and I have to
have it pared down by the morning. Can anyone help?? Thank you very much.

Bob E.
 
Can you give us a sample of a couple of records. It will make it easier to
understand what you are trying to accomplish.

Thanks
 
Dale, Bless your heart for responding. I have copied two records and
shortened the header to letters to save space. I am trying to do the
following: I want to show the complete record for each instance where the
citation in column F ("7007.015" in the first record) matches one of the
citations in column C (e.g. "7017.2020"). Obviously, the two strings in this
example do not match, but, hopefully, this gives you an idea of what I am
trying to accomplish. Thank you very, very much!

A B C D E F G H I J
225 Performance Test Minn. R. 7017.2020, subp. 1; Minn. R. 7007.0800, subp.
4 (PUC order approving MERP, March 8, 2004, Docket No. E-002/M-020633)
EU-001 15 7007.015 Permit required 12/27/1994 05/18/99, 64 FR 26880 Revised
Subp. 2 and 4.
225 Performance Test Minn. R. 7017.2020, subp. 1; Minn. R. 7007.0800, subp.
4 (PUC order approving MERP, March 8, 2004, Docket No. E-002/M-020633)
EU-001 16 7007.02 Sources 8/10/1993 05/02/95, 60 FR 21447
 
Suggest you post some sample values for the two columns. What you posted is
ok but is really hard to read.

Simplest case is that the citiation in F is exactly included in the
citations in C. That can be handled by the following.

Field: C
Criteria: LIKE "*" & [F] & "*"

That would even find a match in the following cases
F: 7007.015 C: 7007.015A
F: 7007.015 C: 97007.015A
F: 7007.015 C: RS7007.015A, 9007.02, abcdefgh

Some more specific examples might help to set better matching criteria.
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
John,

This worked like an absolute charm!! Thanks so much for your help. You are
my hero!

Bob Evans

John Spencer said:
Suggest you post some sample values for the two columns. What you posted is
ok but is really hard to read.

Simplest case is that the citiation in F is exactly included in the
citations in C. That can be handled by the following.

Field: C
Criteria: LIKE "*" & [F] & "*"

That would even find a match in the following cases
F: 7007.015 C: 7007.015A
F: 7007.015 C: 97007.015A
F: 7007.015 C: RS7007.015A, 9007.02, abcdefgh

Some more specific examples might help to set better matching criteria.
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

RSEII said:
Dale, Bless your heart for responding. I have copied two records and
shortened the header to letters to save space. I am trying to do the
following: I want to show the complete record for each instance where the
citation in column F ("7007.015" in the first record) matches one of the
citations in column C (e.g. "7017.2020"). Obviously, the two strings in
this
example do not match, but, hopefully, this gives you an idea of what I am
trying to accomplish. Thank you very, very much!

A B C D E F G H I J
225 Performance Test Minn. R. 7017.2020, subp. 1; Minn. R. 7007.0800,
subp.
4 (PUC order approving MERP, March 8, 2004, Docket No. E-002/M-020633)
EU-001 15 7007.015 Permit required 12/27/1994 05/18/99, 64 FR 26880
Revised
Subp. 2 and 4.
225 Performance Test Minn. R. 7017.2020, subp. 1; Minn. R. 7007.0800,
subp.
4 (PUC order approving MERP, March 8, 2004, Docket No. E-002/M-020633)
EU-001 16 7007.02 Sources 8/10/1993 05/02/95, 60 FR 21447
Click to expand...
Click to expand...
 
Back
Top