Search

[dcarr]

I would like to create a query that is based on a field surname. I would like the query to prompt the user for the first letter of the surname and for the query to return all those results based on the character entered by the user? I cannot seem to do this any ideas? Thanks

 

[pbaldy]

A criteria of this should do it:

Like [Enter a letter] & "*"

 

[dcarr]

Thanks that worked a treat!!