Prompt


H

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
 
Ad

Advertisements

B

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.
 
T

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.

Homer54 said:
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
 
Ad

Advertisements

G

Guest

hi WHA u mean my brother
Bob McClellan said:
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.

Homer54 said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top