I have a report in access that I need to only have employees (“Employee Number”) who have a specific criteria in two text boxes (and/or). So instead of pulling all the employees I would like to only pull employees that have an amount in these two text boxes. I have put the following code on the "Command6_Click" button and it is not working.
Dim strFilter As String
strFilter = "[Text1] >0"
DoCmd.OpenReport "2011 Sick Abusers Letter Union Tbl 10~11 MM Report redo", acViewPreview, , strFilter
The Text Boxes are called Text1 and Text0 and I need the information greater than zero.
Any help is greatly appreciated.