Multiple where conditions?

[Jason1]

I have a report that works from a query. The report has three colums: date, cutter1 and cutter1 total. I have made a form with a view button that has two fields. One is the date, and the other is cutter 1. I would like to view the report based on the records that match the date, and the cutter 1 entries. Cutter 1 is entered as a name. There will be multiple entries on a selected date by each cutter. For instance Cutter 1 may have the name MIKE entered multiple times on the 17th of May, but may have the name LISA entered occasionally. I want a report showing only the instances where MIKE is entered. I want to control this by entering a date, and a name in the fields on the above mentioned form.

I have made this work for the date only using the where condition, but I can't seem to get it to work with the and statement in the where condition. It only returns on record instead of all the records containing the specified date and name. Here is the where condition I am using.

[DATE PACKED]=[Forms]![frmPackingReport]![DATE PACKED] And [CUTTER 1]=[Forms]![frmPackingReport]![CUTTER 1]

 

[jzwp22]

I have made a form with a view button that has two fields

Regarding the form described above, it is a bound or unbound form?

 

[vbaInet]

Put the [Date Packed] under the Date Packed field's criteria row and on that same line put the [Cutter 1] criteria under the Cutter 1 field's criteria row. Don't put the AND criteria under just one field's criteria.