Filter question

  • Thread starter Thread starter Stefan
  • Start date Start date
S

Stefan

I have a text field with a standard format.

##-##. The #'s are always numeric.

I would like to filter my query based on the last two
digits in this field. For example I would like to return
all records with 04 (##-04) as the last two characters.

Can somebody please give me the syntax to use in the
criteria field.

Thanks in advance.
 
I have a text field with a standard format.

##-##. The #'s are always numeric.

I would like to filter my query based on the last two
digits in this field. For example I would like to return
all records with 04 (##-04) as the last two characters.

Can somebody please give me the syntax to use in the
criteria field.

Thanks in advance.
Click to expand...

Put in a calculated field:

LastBit: Right([textfield], 2)

and use 04 as a criterion on this field.

The need to do this makes me suspicious. If the two components of this
field have lives of their own, you should consider having TWO fields
(each two numeric character text fields), and concatenate them for
display purposes.
 
Back
Top