I need to add another piece of Criteria to existing Reports Not sure how to do this.

[logle0917]

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.

[Robeen]

In Design View - on the same Criteria: row:
1. Put = "SFS" under Line Of Business.
2. Put = "ADV" under Auth Type.
3. >= #5/17/2012# under Insert Date.
Make sure all three are on the same Criteria: row. This will put AND between them so that all three have to be true.
Then - if you go to the SQL View - you will see that the three Criteria have AND between them - saying they all have to be true.

Hope this helps!


Let me know if you have questions.