complex multi part query

[teiben]

I have a query which calculates Lagtime: which is the difference between the audit date and the current date.

Lagtime: DateDiff("d",[Auditdate],[Date]) and the criteria is >30
this works fine and shows the reports that are over 30 days overdue.


Now I need: There are 2 fields (both are y/no) Minor and Major. Minor need to be answered >30 and Majors with in >7,

how would I write the expression show me Lagtime if over 30 days for a minor and 7 days for a major.

 

[FoFa]

Abreviated so keep that in mind:
WHERE ((LAGIME > 30 AND MINOR = "Y") OR (LAGTIME > 7 AND MAJOR = "Y"))