Prompt

[Homer54]

Currently using Access 2000. I have this query with purchase order numbers,
need dates, requested by ID, Item number of material, description of material
and so on. I have one column that contains a Cost Center. Cost Center is no
more that the pocket book of the department that is paying for the material.
They are formatted like 16158520, 16158530, 16158540, 16132320, 1613100 and
so on. There are thousands of them. What I am trying to do is just see all
the ones that start with or contain 161585??, so I can get a list that will
have all the 16158520, 16158530, 16158540 and so on. I am probably making
this harder than it really is, but for the life of me I just cannot figure
this out. Any suggestions would be greatly appreciated.--
Homer54

 

[Bob McClellan]

What I am trying to do is just see all

the ones that start with or contain 161585

if you are using access... the query is
WHERE [Cost Center] like *161585*

if you are using SQL... the query is
WHERE [Cost Center] like %161585%

hth,
bob.

 

[Tom van Stiphout]

On Fri, 26 Feb 2010 19:47:28 -0500, "Bob McClellan"

What Bob said, but with single-quotes around the values:
WHERE [Cost Center] like '*161585*'

-Tom.
Microsoft Access MVP

What I am trying to do is just see all
the ones that start with or contain 161585

if you are using access... the query is
WHERE [Cost Center] like *161585*

if you are using SQL... the query is
WHERE [Cost Center] like %161585%

hth,
bob.

Currently using Access 2000. I have this query with purchase order
numbers,
need dates, requested by ID, Item number of material, description of
material
and so on. I have one column that contains a Cost Center. Cost Center is
no
more that the pocket book of the department that is paying for the
material.
They are formatted like 16158520, 16158530, 16158540, 16132320, 1613100
and
so on. There are thousands of them. What I am trying to do is just see all
the ones that start with or contain 161585??, so I can get a list that
will
have all the 16158520, 16158530, 16158540 and so on. I am probably making
this harder than it really is, but for the life of me I just cannot figure
this out. Any suggestions would be greatly appreciated.--
Homer54

 

[Guest]

hi WHA u mean my brother

What I am trying to do is just see all
the ones that start with or contain 161585

if you are using access... the query is
WHERE [Cost Center] like *161585*

if you are using SQL... the query is
WHERE [Cost Center] like %161585%

hth,
bob.

Currently using Access 2000. I have this query with purchase order
numbers,
need dates, requested by ID, Item number of material, description of
material
and so on. I have one column that contains a Cost Center. Cost Center is
no
more that the pocket book of the department that is paying for the
material.
They are formatted like 16158520, 16158530, 16158540, 16132320, 1613100
and
so on. There are thousands of them. What I am trying to do is just see
all
the ones that start with or contain 161585??, so I can get a list that
will
have all the 16158520, 16158530, 16158540 and so on. I am probably making
this harder than it really is, but for the life of me I just cannot
figure
this out. Any suggestions would be greatly appreciated.--
Homer54