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

[Guest]

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'

 

[Rick Brandt]

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'

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] & "*"

 

[Guest]

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.