What I need to do is change this over to say WHERE [AREA] = June search [Application] LIKE ? OR [Section] LIKE ? OR [JBL Part Number] LIKE ? OR [Part Code] LIKE ?I only want it to search within that particular AREA not my whole database. I am assuming this can just be done within this section of the code, but am unsure. ThanksSELECT [Application], [Section], [JBL Part Number], [Description], [Part Code], [Revision], [Hyperlink], [Area] FROM Catalog WHERE [Application] LIKE ? OR [Section] LIKE ? OR [JBL Part Number] LIKE ? OR [Part Code] LIKE ? OR [Area] LIKE ? ORDER BY [Area], [Section] ASC"
where clause tweaking
Posted - 2009-04-15 : 09:46:03