Hi All:
I am in the process of developing a very simple search application. However, I have run into a few road blocks. Firstly, I was wondering as to how to include wild card characters to search for records. I know I can achieve that by using the LIKE criteria of SQL.
Secondly, more importantly , how do I report the results of the search ? Since I plan to use a recordset, I was wondering as to how do I transfer the results of the query onto another form or to a sub-form or even to excel/word application.
Advice, suggestions and tactics are greatly appreciated.
Thanks a million for your help.
Regards,
Info
I am in the process of developing a very simple search application. However, I have run into a few road blocks. Firstly, I was wondering as to how to include wild card characters to search for records. I know I can achieve that by using the LIKE criteria of SQL.
Secondly, more importantly , how do I report the results of the search ? Since I plan to use a recordset, I was wondering as to how do I transfer the results of the query onto another form or to a sub-form or even to excel/word application.
Advice, suggestions and tactics are greatly appreciated.
Thanks a million for your help.
Regards,
Info