Hello,
I'm trying to do a simple query by Street Name with the criteria of:
Like [Enter Street Name:] & "*"
This works great, however.... If I want to search for "University", it will not pull any addresses out because all of the addresses in the database have numbers in front of "University", therefore skipping those records. Is there a way to get Access to pull out records if that input text is included anywhere in the field?
I know I'm making this sound more than complex that it is...
Thank you again, this forum has definately saved me.
-Rob Smith
I'm trying to do a simple query by Street Name with the criteria of:
Like [Enter Street Name:] & "*"
This works great, however.... If I want to search for "University", it will not pull any addresses out because all of the addresses in the database have numbers in front of "University", therefore skipping those records. Is there a way to get Access to pull out records if that input text is included anywhere in the field?
I know I'm making this sound more than complex that it is...
Thank you again, this forum has definately saved me.
-Rob Smith