I have a table where the data in two fields relate to the same thing.
Name Address Suburb State Council 1 State Council 2
Phil Over-the-Hill Far Away Anderson Peterson
Michael Lost Tree Neverneverland Clarke Louis
Gregory Sherwood Red Riding Hood Phelps Anderson
In the above example, I would like to be able to have a query that allows me to show the records that contain 'Anderson'. Ultimately, I would like to have the option to enter in the search data, but first - the baby steps.