Access, taking sections a string 1

[SellOut]

Hello,

I have a column with lots of values in the format '12PR' ie number, number, letter, letter. In fact they are all two digits followed by the letters 'PR' unless they are null or a '-' neither of which I want to include in my final result. I would like to just have the numbers in a query in a new column (I can't change the original table). I want something that has the same effect as 'Left' does in excel or something that will save numbers and remove letters or remove specific letters.

Is this possible in the design view?

Thanks

SO

 

[ETID]

add a new column in your query...
and in the filed row type something like....

Just_numbers:=left([table_in_question]![field_in_qustion],2)

...substite actual names in brackets

 

[SellOut]

Thats great thanks. I haven't used Access for a bit and I am pleasantly surprised how easy that is to do!

Cheers,

SO