I have a query field comprising a text string of seven digits, eg 2220603.

The following criteria works ok, as does replacing the wild card groups with, eg, the contents of a text box.

Like "???" & "06" & "??"

But how can I make the middle group something like >=06 please/


Clive Astley

__________________
Clive Astley

use hte mid function
Mid([Fieldname],4,2)

4 is the beginning of the string, 2 is the length

then check if value >06



Sal

Thanks Sal. That's ok for just testing the middle bit. But how do I join it to the other two tests?

Like "222" & Mid([FieldName],4,2)>06 & "04"

doesn't work.

Clive Astley

sounds like you are trying to do this

Left([FieldName],3) and
Mid([FieldName],4,2)>06 and
right([FieldName]),2)="04"

You are looking for all 3 to be true. Is that right?

Anyway, search the Access help for "Expresions". There you can lookup the expressions for text.



Sal

Thanks again Sal. Got it now. Don't know why I had the difficulty with it; have used similar in the past. I seem to have got into the mindset of using the Like operator. Senior moments of old age! Thanks again and best wishes,

Clive Astley