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..
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..
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,
Think I might have solved it using the "Len" function.
Cheers,
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.
Thanks, yes Len function works fine so sorted now.
Cheers, Steve
Sorry I misunderstood, and welcome to the site by the way!
Cheers, and as an Access newbie.. it looks like I will be using it a lot in the weeks to come..
Thanks