String Query

[Caysteve]

Hi, Can enyone tell me what code to use to return a query for a specific number of charachters on a string..



I want to screen postcodes between 6 digit and 7 digit in query reports..


thanks..

[pbaldy]

Check out the Mid() function.

[Caysteve]

Thanks Paul, but the MID fnction seems to return a section of the string rather than seperate them out.. eg .. if I select 6 as the length it will return 6 charachters out of a 7 string record.

I need to be able to sort , 6 character and 7 character postcodes and then use the Left function to search.

IE SO20xxx and not SO20xx if that makes sense..

cheers,

[Caysteve]

Think I might have solved it using the "Len" function.

Cheers,

[pbaldy]

Perhaps I misunderstood the goal. The Mid() function would have let you peel out the 6th and 7th characters. Did you mean codes 6 or 7 characters long? If so, yes the Len() function is more appropriate.

[Caysteve]

Thanks, yes Len function works fine so sorted now.

Cheers, Steve

[pbaldy]

Sorry I misunderstood, and welcome to the site by the way!

[Caysteve]

Cheers, and as an Access newbie.. it looks like I will be using it a lot in the weeks to come..

Thanks