Query Question

[Alireza355]

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.

[ADezii]

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.

Try the following as a Criteria:

>=[Forms]![frmSearch]![txtSearchField] & "*"

[Alireza355]

Thanx a lot

Thank you so much.

It worked...

[ADezii]

Thank you so much.

It worked...

You are quite welcome.

[OldBirdman]

Isn't the trailing "*" superfluous? Searching for >="R" or >="R*" would be the same because * is lower than "A" in the ASCII table. If the * is a wildcard character, doesn't if have to be used with the keyword "Like"?

[ADezii]

Isn't the trailing "*" superfluous? Searching for >="R" or >="R*" would be the same because * is lower than "A" in the ASCII table. If the * is a wildcard character, doesn't if have to be used with the keyword "Like"?

I think you may be right on this one OldBirdman, nice catch! BTW, no luck on Downloading the DB, so I gave you my E-Mail Address as a Reply to your PM.