Afternoon guys, i have a column in my table called Location Code which has a 5 figure number in it.
what i would like to do if possible is in a view that i get the option to type in the first 2 digits and it pulls everything under those two numbers.
user input would be example = 31 and the output from this should be 21 rows as there 21 items stored under the location code. or if you wanted to look at 31 to 34 it would return 36 rows.
Location code is made up of 5 digits eg 31001 - first number is 3 is the cupboard number (5 altogether), second number is 1 which is the shelf number and last three digits is the item number i need to be able to view everything for the first two digits only.
hopefully this makes sense.
thank you all for your time - Jase
LinkedIn
Twitter
