I am fairly new to Database creation and have devised a nice database which does what I am hoping to do. Though I am sure there is an easier way of accomplishing many of the tasks I have done, as I learn I will adapt & change.. but.

currently I want to create a query which will show me records which Contain the word "Checked-In" in any of 4 columns. So for example:

TABLE = Patient Visits
Columns...