Board index Office Access

Determining Whether a Specific String Exists in a Field

Determining Whether a Specific String Exists in a Field

Post by L.A. Lawye » Thu, 11 Dec 2008 02:01:36


I want to determine whether a specific string of letters exists in a field
on the current field.

How is that done?
 
 
 
Top

Determining Whether a Specific String Exists in a Field

Post by Douglas J. » Thu, 11 Dec 2008 02:08:53

You can use LIKE for the criteria of a query:

SELECT Field1
FROM Table1
WHERE Field1 LIKE "*Lawyer*"

or you can use the InStr function.

--
Doug Steele, Microsoft Access MVP
http://www.yqcomputer.com/
(no e-mails, please!)

 
 
 
Top

1. Copy all data from a:Class A's fields to the namesake fields of b:Class B.

2. Summing N/A's

3. Finding the Value (of text and numbers) between N/A's

4. How could I ask Thread B to call B().Method() from inside Thread A's run?

5. How could I ask Thread B to call B().Method() from inside Thread A's run?

6. Printing report b after report a prints using report a's variables

7. Capture image of App#A's window from App#B

8. using "if" but omitting the #n/a's

9. lookup only finds #n/a's

10. delete #N/A's in Excel

11. Formula's with #N/A's

12. How do I only get valid "answers" in a VLOOKUP function (no #N/A's

13. more a's than b's

14. how do u invoke Tag b's Tag Handler from within Tag a's tag Handler?

15. Why does Form-A's instance fire Form-B's event??

All times are UTC
Board index