Wildcard not working in MS Query?

[Ben171]

I am trying to run a very easy query, however i am having an issue with a wildcard.

Lets for example, i have a database full of customers. Lets say 3 customers i have are "Example" "Example2" "Example3"

I am trying to run a query in which the user enters the customer name and it will display the data.

IN MS Query i've used Like [Customer Name]

However upon entering "Example%" in the box that comes up, only Example is displayed, and not example2 and example 3.

Any help would be appreciated

 

[John_w]

The % character should match multiple characters. What are you entering for the "dated" field criterion? Is that affecting the data returned?

 

[Ben171]

The % character should match multiple characters. What are you entering for the "dated" field criterion? Is that affecting the data returned?

that's what i thought, that's why i am super confused! nope, i've set the date to 01/01/2016 as i am trying to find data after that date (there are hundreds of rows of data that should be produced after this date)