>How do I perform a search of the data within the records of an Access .mdb >file. I've used AtomZ for basic text searching of the static content, but >what about the content in the database itself?
If the columns are called 'firstname', 'lastname' and 'address', you should be able to use SELECT firstname, lastname, address FROM DatabaseName WHERE firstname LIKE "*keyword*" OR lastname LIKE "*keyword*" OR address LIKE "*keyword*" Regards, David ____ � The WDVL Discussion List from WDVL.COM � ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub ________________ http://www.wdvl.com _______________________ You are currently subscribed to wdvltalk as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
