Deleting specific text within a field in a query 1

[Triacona]

Dear all,

I have a Table: sheet 1.
I have a Query: List of templates

I have entries in the first field in the table i want to remove.
The first field: Description is the field in question.

In the begining of the field I have 2 characters which I do not want there.

I want to remove within every field the first two characters...

How would I do this in a query?

Any help would be greatly appreciated

Kind regards

Triacona

 

[PHV]

SELECT Mid([Description],3) AS NewDescription

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Triacona]

Brilliant!!
Thank you!!!
I setup a new field in the Query

NewDesc: Mid([Description],3)

Kind regards
Triacona

 

[BigRed1212]

Just to check an outside possibility: That isn't actually removing anything or altering the data if that is what you want.

If your data was
aawarthog

and you want to change the actual data in the database and remove the aa to make it
warthog

you would need to do something else.