Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Filtering data 1

Status
Not open for further replies.

VAMick

Programmer
Nov 18, 2005
64
US
I've got a fairly unique situation where i need to filter out records based on a location code. I have two regions in a warehouse, Quickpick and then Stock.
The Quickpick locations have a code of a letter followed by 3 numbers (A001, B203). The Stock locations are 2 letters and a number (FJ4, CA1).
I need to be able to filter out the locations that are 2 letters and a number, returning only items that would be from the first area, Quickpick, that has Letter and 3 numbers.
So.....
anyone know how i should write this?

Thanks in advance.
 
Look at the Len of the field:
Len([Field])=3 'Stock
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top