Prompt

  • Thread starter Thread starter Homer54
  • Start date Start date
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
 
What I am trying to do is just see all
the ones that start with or contain 161585
Click to expand...

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.
 
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
Click to expand...

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
Click to expand...
Click to expand...
 
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
Click to expand...

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
Click to expand...
Click to expand...
 
Back
Top