Finding Records starting with a letter

  • Thread starter Thread starter Brian
  • Start date Start date
B

Brian

I need to find all records with a the field starting with the letter "S".
This table holds many records and there is a field that contains items
containing various locations, but starting with the letter S (i.e. SA101,
S345, 123ab, ss256, bcd...).
I want to end up only locating SA101, S345 and ss256.

What do I put into the sort routine to produce this?
 
I need to find all records with a the field starting with the letter "S".
This table holds many records and there is a field that contains items
containing various locations, but starting with the letter S (i.e. SA101,
S345, 123ab, ss256, bcd...).
I want to end up only locating SA101, S345 and ss256.

What do I put into the sort routine to produce this?
Click to expand...

As criteria on this column in your query, write:
Like "S*"

What do you mean by 'into the sort routine'?
This has nothing to do with sorting.
 
Back
Top