query for fields with just nine numeric digits

[stirlsa]

In a query I want to search for data in a text field called MEDSID within a table called CLIENT.

I want to search for records in which MEDSID field has 9-digits only of all numeric text.

Is there any way to do so?

Thanks in advance for any adivce.

 

[giacomo]

If it's a text field you can use the len() function to return the number of characters.

SELECT * FROM CLIENT WHERE len([MEDSID]) = 9;

hth,
Giacomo

 

[richard3x3]

hope this helps

create a new variable in your query called character numbers : use the character number function, use help to find it, this should give you the answer of the number of characters , select 9 in that field then filter with a parameter query in your search field.