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/