Dear all,
I am tring to have a query that returns all the rows beginning with a character to the end of the table.
Example:
Alfa
Beta
Charlie
David
Easy
Fox
Golf
Honey
results I want is: when entering as criteria: D
David
Easy
Fox
Golf
Honey
I tried using this: Like [forms]![frmSearch]![txtSearchField] & "*"
But this only returns all items starting with D
Thanx a lot.