How to run a query on a partial name in a field in Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Talloulah - 23 Nov 2005 15:30 GMT

What criteria do I need to enter to run a query using wildcards to find a
name within a field but only have a partial name to enter e.g. entering
'health' when the output required is 'Health and Social Care'

As the naming field has more than one entry, the criteria for entry in the
query will need to be entered using wild cards but I cannot get the query to
find all records greater than 'Health'

Reply to this Message

Rick Brandt - 23 Nov 2005 15:43 GMT

> What criteria do I need to enter to run a query using wildcards to
> find a name within a field but only have a partial name to enter e.g.
[quoted text clipped - 3 lines]
> in the query will need to be entered using wild cards but I cannot
> get the query to find all records greater than 'Health'

For all records beginning with "health"...
WHERE FieldName Like "health*"

For all records containing "health"...
WHERE FieldName Like "*health*"

If you want a self-prompting parameter...
WHERE FieldName Like "*" & [Enter search criteria] & "*"

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message

Talloulah - 23 Nov 2005 17:01 GMT

If I run the last query mentioned it still show up no records. Does it
matter that the field the criteria is for is a multi choice drop down box
with quite a few entries? All I am trying to do is run a query to find out
the number in each catergory shown in the drop down box.

> What criteria do I need to enter to run a query using wildcards to find a
> name within a field but only have a partial name to enter e.g. entering
[quoted text clipped - 3 lines]
> query will need to be entered using wild cards but I cannot get the query to
> find all records greater than 'Health'

Reply to this Message