By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,483 Members | 1,909 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,483 IT Pros & Developers. It's quick & easy.

Query - Expression !

P: n/a
Hi All,

I am new user of Access database. Need help to create an expression to
filter out specific item #. The query contains two field:

1) store number
2) item number - the item# are 15 digits alphanumaric
e.g{01010000CARR001}
THE ITEM IS A TEXT FIELD!!!

Now i want the query to just show me item# where character 8 and 9 of
the item# are have zero. some thing like this... {######00#######}

Thanks,

Rashid

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
rj*******@hotmail.com wrote:
Hi All,

I am new user of Access database. Need help to create an expression to
filter out specific item #. The query contains two field:

1) store number
2) item number - the item# are 15 digits alphanumaric
e.g{01010000CARR001}
THE ITEM IS A TEXT FIELD!!!

Now i want the query to just show me item# where character 8 and 9 of
the item# are have zero. some thing like this... {######00#######}

Thanks,

Rashid


Select * from [tablename] where item# like '???????00*'

--
[Oo=w=oO]

Nov 13 '05 #2

P: n/a
Where mid([ItemNumber],8,2) = "00"

Fred

--
Message posted via http://www.accessmonster.com
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.