If the logic between the yes/no check boxes is "or" the following query might point you in the right direction - - SELECT tblBookData.ISBN, tblBookData.Category, tblBookData.Publisher, tblBookData.House, tblBookData.Genre, tblBookData.Auth1First, tblBookData.Auth1Last, tblBookData.Auth2First, tblBookData.Auth2Last, tblBookData.Title, tblBookData.Month, tblBookData.Year, tblBookData.Vol, tblBookData.Number, tblBookData.Series, tblBookData.Format, tblBookData.Notes, tblBookData.Holiday, tblBookData.Keywords, tblBookData.Language, tblBookData.Reviews, tblBookData.Price, tblBookData.SoldOut FROM tblBookData WHERE tblBookData.Category=[Category?] Or tblBookData.Publisher=[Publisher?]; ; If you just execute the above query it will prompt you for, in this case, Category and Publisher. I haven't set up a form. When I do I will post the solution. Dick
--- In [email protected], "Mo" <[EMAIL PROTECTED]> wrote: > > I need a form that will filter by category (and also be able to by > Keyword, but that may be for a later post). > I'm well comfortable enough doing basic table and query stuff, but this > one is beyond me. > > Here's the skinny: > I have a simple table (Movies_tbl) for my movie library. > Fields are Title, Year, Synopsis and then about 20 Yes/No fields for > Categories (Drama/Action/Comedy/...). > I would like to have a form which has checkboxes for each category.If i > wanted a Comedy-Drama, I could tick those two boxes and all matching > titles get listed alphabetically. > > This seems like too many variables for a form, but then again, what do > I know ;-) > > Any help or questions will be greatly appreciated. > -Mo > Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/ms_access/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> 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/
