Hi, Jeannette.
and Last name), it is working perfectly. What I want to do is: run the query
but be able to type just a few letters of the username.
You haven't shown us your SQL code so we can only offer example syntax. If
your dates are coming from a parameter query, too, then the syntax in your
WHERE clause would be:
WHERE ((UserName LIKE [Enter first few letters of user's name:] & "*") AND
(SomeDate BETWEEN [Beginning Date:] AND [Ending Date:]));
If the dates are coming from a form, then the syntax would be:
WHERE ((UserName LIKE [Enter first few letters of user's name:] & "*") AND
(SomeDate BETWEEN Forms!MyForm!FromDate AND Forms!MyForm!ToDate));
HTH.
Gunny
See
http://www.QBuilt.com for all your database needs.
See
http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are
[email protected] and
[email protected]
- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. Remember that questions
answered the quickest are often from those who have a history of rewarding
the contributors who have taken the time to answer questions correctly.
