Query

  • Thread starter Thread starter Disturbezz
  • Start date Start date
D

Disturbezz

What do i write in a query so that when i write in a
letter it will select all the items under that letter
 
How about providing an example of some sample records and what you would
like to enter and what you would expect the results to be?

It's not clear what you mean by "under that letter".
 
What do i write in a query so that when i write in a
letter it will select all the items under that letter
Click to expand...

Could you describe what you mean by "under that letter"? What is in
the field you're searching in the table? What do you want to find? If
you could give an example of the data it might be easier to reply.
 
I think this is what you're looking for...

In your query, for the criteria of the field which you
want to filter on, add this:

Like [Enter letter] & "*"

When you run the query, it'll prompt you to enter a letter
(you can enter more than one letter). Enter a letter and
the query will return records where the field begins with
that letter.
 
Back
Top