locked
Microsoft Access 2003 RRS feed

  • Question

  • Our small staff is undergoing reorganization and I have no one here who knows how to use Microsoft Access 2003, myself included. I am trying to query and filter a table so that I can print address labels for a bulk mailing to selected individuals. The query part seems to go OK, using the simple Query Wizard. I get a datasheet of the table's entire database that has the criteria (fields) I selected and has checkmarks in the fields' boxes when an individual matches a criterion, such as having donated money in 2012 or having attended our annual luncheon in 2012.  I'm running into problems when I try to filter that list to eliminate individuals who don't match a single one of the filter criteria and leave in the list individuals who matche at least one of the criteria. When I go to the "Records" drop down menu and go to "filter by form," I can't find a way to filter in a way that selects people who meet criteria 1 or criteria 2 or criteria 3, etc. The filter gives me only people who match ALL of the checked criteria (fields).  I don't know if I'm using the appropriate options for the query or the filtering, and, if so, how to execute the filtering properly.  
    • Moved by Bill_Stewart Thursday, July 11, 2013 6:39 PM Move to more appropriate forum
    Thursday, July 11, 2013 6:24 PM

All replies