Query criteria...

[116]

I have a name field that is random in length. I have been trying to
configure LEN, RIGHT, LEFT with no luck trying to strip the right 9
characters which are the same on every value. Any assistance would be
greatly appreciated.

Thanks
David

 

[Golfinray]

Try right([yourfield],9)

 

[116]

Thanks you, but that displays the 9 characters to the right. I wish to strip
them when the query runs.

David

Try right([yourfield],9)

I have a name field that is random in length. I have been trying to
configure LEN, RIGHT, LEFT with no luck trying to strip the right 9
characters which are the same on every value. Any assistance would be
greatly appreciated.

Thanks
David

 

[archie]

i gosa jhasdkj sit

 

[Douglas J. Steele]

Semantics! <g>

To some people, saying "strip off the right 9 characters" means "only
display the right 9 characters". Obviously to you it means "display
everything except the right 9 characters".

That would be

Left([yourfield], Len([yourfield]) - 9)

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Thanks you, but that displays the 9 characters to the right. I wish to
strip
them when the query runs.

David

Try right([yourfield],9)

I have a name field that is random in length. I have been trying to
configure LEN, RIGHT, LEFT with no luck trying to strip the right 9
characters which are the same on every value. Any assistance would be
greatly appreciated.

Thanks
David

 

[116]

Thanks Doug. I see my mistake.

David

Semantics! <g>

To some people, saying "strip off the right 9 characters" means "only
display the right 9 characters". Obviously to you it means "display
everything except the right 9 characters".

That would be

Left([yourfield], Len([yourfield]) - 9)

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Thanks you, but that displays the 9 characters to the right. I wish to
strip
them when the query runs.

David

Try right([yourfield],9)

:

I have a name field that is random in length. I have been trying to
configure LEN, RIGHT, LEFT with no luck trying to strip the right 9
characters which are the same on every value. Any assistance would be
greatly appreciated.

Thanks
David

 

[116]

Thanks Doug. I see my mistake.

David

Semantics! <g>

To some people, saying "strip off the right 9 characters" means "only
display the right 9 characters". Obviously to you it means "display
everything except the right 9 characters".

That would be

Left([yourfield], Len([yourfield]) - 9)

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Thanks you, but that displays the 9 characters to the right. I wish to
strip
them when the query runs.

David

Try right([yourfield],9)

:

I have a name field that is random in length. I have been trying to
configure LEN, RIGHT, LEFT with no luck trying to strip the right 9
characters which are the same on every value. Any assistance would be
greatly appreciated.

Thanks
David

 

[wj]

I have a name field that is random in length. I have been trying to
configure LEN, RIGHT, LEFT with no luck trying to strip the right 9
characters which are the same on every value. Any assistance would be
greatly appreciated.

Thanks
David