98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Access Training and help » Action Queries
Action Queries
Resolved · Low Priority · Version 2003
Olyemisi has attended:
Access VBA course
Access Introduction course
Access Intermediate course
Access Advanced course
Access VBA course
Project Intro Intermediate course
Action Queries
under a query, where you have a *IT* can you query benefit as a query. e.g Benefit IT Office
RE: Action Queries
Dear Olyemisi
Thank you for attending Access Courses. I hope you enjoyed courses and have started to put them into practice.
Sammie who was in the same training has also asked teh same question. Therefore I am copying and pasting the response.
I am not sure it this is the definite answer but you can try this and I am confident that it will work
In the Job Title field in the Design View of the Query type the following:
* IT (Please note that there is a space between * and IT)
IT *
* IT * (Please note that there is space before and after IT)
This should be entered in the same line on the Job Title field.
Please try it and tell me if that helps you or not.
I hope this has helped in answering your query. If this has answered your question then may I please request you to mark this post as resolved!!
Many thanks
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000/2003
MCAS Master Instructor 2007
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:Design View in Relationship windowYour in the Relationship window and changes are required to be made to a Table's design. |