I am frustrated, how to shorten a field's data

[GreekPatriot]

if I have as field with the following values how can I transform them to the following using a query formula:
10 to 10
10.1 to 10
10.1.1 to 10
11 to 11
11.1 to 11
11.1.1 to 11
0 to 0
1 to 1
1.1 to 1
1.1.1 to 1

It cats all the strings after the first dot.

Your help will be appreciated

 

[GreekPatriot]

cat = cut sorry for the spelling mistake

 

[PHV]

Expr1: Left([fieldname],InStr([fieldname] & ".",".")-1)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[GreekPatriot]

I appreciate it PHV. This finally works. Cheers I dont know what I would do without your help cheers.