Query Select first digits

[Joanna_gr]

Hi again. Can you please help me on this? I'm trying to create a query from a list of data that some of them begins with 3digits like "283 - name" and some other with 4 digits like "2222 - name". Can you tell me how to select all records that start with 4digts? Like LEFT in excel.

 

[Norie]

Well you can use Left in Access just as you do in Excel.

Does the - always seperate the number and name?

 

[Joanna_gr]

I tried to use LEFT but it didn't work. how can I use it in a query? Yes the - always seperates numbers from text.

 

[Norie]

How are you trying to use it?

You could try something like this.

Expr1: Left([Field1],InStr([Field1],"-")-2)

 

[Joanna_gr]

Well, i'm afraid I did not make myself clear enough. This solution seperates numbers from text. This is not what I want. In fact I need to have all records that start with 4 digits and exclude records that start with a 3digit num. etc
3333 - name1
3434 - name2
3432 - name3
something like filtering the column and keep only records with 4dgt and hide all other. (In my list I also have records starting with 2 num. "22 - name1".

 

[Norie]

Well you could use this expression.

Expr1: Len(Left([Field1],InStr([Field1],"-")-2))

And set the criteria to 4.

 

[Joanna_gr]

That's it! Thank you very much!