Filter by Criteria Selection

[HD20]

I have a query with a field of names and I would like to have a filter option, but still maintain the capability to show all records. I put [Enter Name] in the criteria section of the query so it prompts the user to enter a name and if they enter Joe Smith, his records appear.

Is there a way to enter something that would give all records? I tried leaving the prompt blank and I tried putting in "*", neither worked.

Thanks in advance for your help.

 

[Nouba]

Try this one with just hitting enter for getting all records

SELECT
  Lastname
FROM tblPeople
WHERE Lastname Like [Enter Name] & "*"

HTH nouba