Thank you all for your help.  

Quoting "A.D.Tejpal" <[EMAIL PROTECTED]>:

> 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

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/AccessDevelopers/

<*> 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/
 


Reply via email to