Using query to extract data based on numbers

[Gazza2]

I have a table with a field named BinNo which has a list of items with a bin no in the format 1.234( this number can be any number up to 6000.9999).

Is there a way for me to have a field on a form where I enter a number (i.e 1) and it lists all the items with a 1 before the decimal point but not 10 or an other number with a one in it. If I enter 10 then it will only give me the items with 10 before the decimal point and not 11 etc.

I have a query that pulls all the data into it but I only want the query to show the items relating to the number I enter into the form field.

Hope this makes sense.

Thanks
Gareth

 

[Brianwarnock]

I wonder if

Like '1.*'

Works

If so

Like forms!formname!controlname & '.*'

Would be worth a try

Brian

 

[Gazza2]

Thanks Brianwarnock worked like a charm