Hi
I am new to Access and this may seem a very simple thing to some of you, but I am trying to build a simple search engine for my database. “Well simple to use anyway”.
I have 5 columns in my database with 1000s of rows of data.
I have built a form called “Form1” with 5 text fields (unbound) called “Text1”, “Text2” etc… and 1 command button called “Command1” that will run a Report and display the results of all 5 fields.
All I want to be able to do is type text in ANYONE of the 5 text fields on the form and it produces a report of my findings. The more text fields I use the smaller the report as it narrows down the search.
I just can’t build a query to accomplish this, could anybody guide me in the right direction.
Thanks
I am new to Access and this may seem a very simple thing to some of you, but I am trying to build a simple search engine for my database. “Well simple to use anyway”.
I have 5 columns in my database with 1000s of rows of data.
I have built a form called “Form1” with 5 text fields (unbound) called “Text1”, “Text2” etc… and 1 command button called “Command1” that will run a Report and display the results of all 5 fields.
All I want to be able to do is type text in ANYONE of the 5 text fields on the form and it produces a report of my findings. The more text fields I use the smaller the report as it narrows down the search.
I just can’t build a query to accomplish this, could anybody guide me in the right direction.
Thanks