Re: [AccessDevelopers] Multiple search query...

[A.D.Tejpal]

MartyBevo,       My sample db named ArchivesManager might be of interest to you. It is available at Rogers Access Library (other developers library). Link - http://www.rogersaccesslibrary.com       You could adapt the underlying approach suitably, for your specific needs.   Best wishes, A.D.Tejpal --------------   ----- Original Message ----- From: martybevo To: AccessDevelopers@yahoogroups.com Sent: Thursday, January 26, 2006 01:32 Subject: [AccessDevelopers] Multiple search query... Hi all, I'm trying to create a search form to basically filter out results.  I have a form with 4 fields, all combo boxes. Field A - is name Field B and C - will be used for a date range Field D - is title I want to be able to filter a query whether 1,2,3 or 4 fields are populated or not.  Meaning, if I select fields 1 and 4 then i will only see those results. I'm able to accomplish these queries separately but have no idea on how to combine them to create an advanced search. If anybody can assist me or point me in the right direction I would appreciate it. Thank you. Please zip all files prior to uploading to Files section. YAHOO! GROUPS LINKS  Visit your group "AccessDevelopers" on the web.    To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.