Search results

thanks I got it to work! I didn't need to add a new column though- just added a -1 in the Or Criteria

A related question: I have a query that filters the field SiteID(text field) to generate a report This is what I have in the query now: [Forms]![PathogenData]![SiteID] I added the "All" to my combo box(SELECT DISTINCT tblPathogens_all.SiteID, tblPathogens_all.Agency FROM tblPathogens_all UNION...

Hi, I am trying to set parameters in a form to create a report based on a query. I have three fields that I want to use as part of my form to output a report. Date (text boxes) Agency (combo box) SiteName (multi-select list box) I have already specified a specific date range, and this works...