Formula for pulling certain data

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

Guest

We have an employee database, one of the fields is the
Classification of there drivers license (C, B, A, etc)
Some of the employees only have a license permit, so next
to the Classification I was putting in (P) for permit. If
that was the only data in the field, I could use the
expression, "In ("(P)") but there is another letter in
that field. How can I create a formula that will pull all
employee records having the "(P)" in the classification
field, regardless of what "other" letter is also present
in the field.
Thank you for help in advance, and if possible, more than
one solution always helps me understand better!!
Thanks,
Kari
 
To solve the problem, use LIKE as

Field: Classification
Criteria: Like "*P*"

BUT, you should probably be storing only one piece of information in the field.
You should either have an additional field for the other bits of information OR
a table to contain the information with a field to identify the employee and a
field to identify the licence type. Then you could have multiple records for
the client with each peice of information.
 
Back
Top