Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

query

ResolvedVersion 2003

Sammie has attended:
Access Intermediate course
Access Advanced course

Query

How do I set up a criteria say anything containing IT but not any IT within a word say benefIT?
Thanks.

RE: Query

Hi Sammie,

I have just tried something which seems to work, though it brings up text with the word 'it' in not just the capital version as in Information Technology. If you wanted the latter only, there is probably a way of doing that too.

I used the following: Like "* IT *"

So I used a space either side and also wildcards on the outside of these so that IT can be anywhere in the text field to work.

If you wanted 'IT' and not 'it' let us know and I'm sure someone will have or will find the answer

Regards, Mark

RE: Query - Using wildcards

Dear Sammie
Dear Ben

Thank you for attending Access courses. I hope you enjoyed the courses and are finding the topics covered during the training useful.

What Mark has suggested wil provide you the result but if you have IT as the First Word or the last word then it can be a bit of a problem.

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

Access tip:

Related tables

When you have related tables such as Customers and their Orders, the Customer table is the Primary table.

Open the Customers table in datasheet view and go to the Home Tab and Records group. Click on the More option and choose Subdatasheet and then click on Subdatasheet again. Now choose the related table (Orders) and click ok.

Now you can click the + symbol by each company to show the related orders.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.