The new rule for Line of Business = SFS is that we never did auths for them until 5/17/12. So- we have excluded them from the report.
Now as of 5/17/12- they are allowed to be on the report- but only if Auth Type = ADV.
So- currently report excludes SFS So now it needs to – exclude SFS if insert date prior to 5/17/12
How can I do this in the Design view will this not conflict with the date that excludes: I think what I need is Show all Line of Business = "SFS" After Insert Date >= #5/17/2012# AND Auth Type = "ADV" Not sure how to do this.