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
letter it will select all the items under that letter
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Duane Hookom
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".
like to enter and what you would expect the results to be?
It's not clear what you mean by "under that letter".
J
John Vinson
What do i write in a query so that when i write in a
letter it will select all the items under that letter
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.
M
MarkD
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.
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.