return results

[Guest]

Hi
I have a table with telephone numbers on it and i only want the numbers
stsarting with 02890 to show up. there are seven numbers that should appear,
however when i put this in only one appears (Like "02890*"). can any one help.
thanks

Monty

 

[John Vinson]

Hi
I have a table with telephone numbers on it and i only want the numbers
stsarting with 02890 to show up. there are seven numbers that should appear,
however when i put this in only one appears (Like "02890*"). can any one help.
thanks

Monty

Where are you "putting this in"?

Create a new Query based on your table.

Put the LIKE expression on the criteria line under the fieldname.

Open the query datasheet.

John W. Vinson[MVP]

 

[Guest]

That is strange. Could the zeros actually be the letter 0. I've seen that
before. How about leading blanks? Go to the table and sort A to Z and see
what happens.

Also if this is a number, not text, field, the leading zero is being put in
by formatting. Could be something going wrong there.

Tell you what, thy this in a query and see what happens:

Like "*289*"

Sort on that field. See what shows then and where.