Thanks, but sorry...can you give me a little more details. I mean, wouldn't that still end up as a huge statement of ORs...just built with vars? Sorry...just not sure what you mean.
Dian ~ -----Original Message----- From: Anna Crooks [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 25, 2004 9:54 PM To: [EMAIL PROTECTED] Subject: RE: [ASP] Multi Criteria Searches You should be able to write an Access Query and pass the variables to it. Not as quick as an SQL Server stored proc but better than executing the full query from the web page. HTH Anna --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.742 / Virus Database: 495 - Release Date: 8/19/2004 ------------------------ Yahoo! Groups Sponsor --------------------~--> $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/17folB/TM --------------------------------------------------------------------~-> --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
