98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft+access+training+course - Access
microsoft+access+training+course - Access
Resolved · Low Priority · Version Standard
Tue 28 Nov 2006, 12:41Delegate Surinder said...
Surinder has attended:
Word Advanced course
Excel Advanced course
Access
How do I compare data in access i.e example doing a V lookup in excel
Tue 28 Nov 2006, 13:34Graeme (guest) said...
RE: Access
You may want to try a Like query entering
Like "*" & [Enter Match] & "*"
in the condition line of the fields you want to search
This will search across as many fields as you type the code into on the query for the values that you enter in the [Enter Match] peramiter
Graeme.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Space marksIt is good practice not i to have space marks for field names as this can lead to problems when using queries or VBA code. It is much better to use an underscore charcter to represent spaces in field names |
