Got a report that is working well, it has a selection criteria so that it prints specific records (tblRep.Rep) but also need it print when the Rep record is also null.

 

Example data:

Ticket   Date       Project   Rep   Sell Price

125      11-1-12  101        Bob   $205

203      11-2-12  105        Suzy  $34

204      11-2-12  108                 $56

208      11-3-12  110        Bob   $512

 

Selection formula says only print data where Rep=Bob data (Tickets 125 & 208) but would also like to print the blank Rep data as well (Ticket 204).

 

Thoughts on how to accomplish this would be greatly appreciated!

I reversed the formula and it's working now :)