Criteria for Text fields in Query in MS Access - Office 365

Criteria for text fields can be specified in different ways. You can specify to retrieve records from a table with a matching value or not matching values. You can use Like with asterisk to retrieve records from table that begin, end or contain a specific string. You can also use comparison operators greater than, less than etc to retrieve the records. Any of the criteria can be applied to both "Short Text" and "Long Text" data type fields in the table. This video explains in detail how to specify different criteria in query to retrieve records.

[@CheyenneAuntie]

OMG THANK YOU SOOOOO MUCH!!! You are a life SAVER!

[@FindEasySolution]

You are welcome. Please subscribe to our channel.

[@Anibbyy]

Omg thanks so much, you're a legend. You saved my life

[@user-cp5fb3vw4z]

Thank you. This is what I need!

[@FindEasySolution]

You are welcome. Please subscribe to our channel.

[@jlal3167]

i have a question : if you have criterias which are a line of text and you are looking for a peculiar word which is in different answers. Ex : there is like, "Mesozoic, Jurassic, Callovian", Mesozoic, Jurassic, Toarcian" but also "Paleozoic, Devonian, Givetian", how can I express to my query that I only want the answers containing "Jurassic" ? Thank you

[@insidious713]

you are the best

[@prince.5921]

Lifesaver 🙌🏻👏🏽👏🏽👏🏽💀

[@FindEasySolution]

Thank you for the appreciation. Please subscribe to our channel.

[@vanessachartrand4239]

Thank you very much!

[@FindEasySolution]

You are welcome

[@satyabanukil779]

Here your parameter is taken from one field. Can it be done from more than one field

[@alzirabuta8817]

Thank you so much 🙏 watched your other videos and u are a lifesaver truly 🤗

[@FindEasySolution]

Thank you for the appreciation. Please subscribe to our channel.

[@defenderws]

Thank you

[@FindEasySolution]

You are welcome