Conditional Query

[LFC]

I've been racking my brain trying to think of the best way to do this, but have no idea how. I have line items that get audited with different frequencies (i.e. Monthly, Mondays, Twice a week, Every 2 weeks). I'm trying to get a query that will show which ones have not yet been entered for a specific date that need to be entered. I have a query showing the last audit date that works fine, but I'm struggling with where I should go from here.

Thanks

 

[vbaInet]

Double posting LFC

 

[LFC]

haha...sorry, i had posted in the vba one and then realized it prolly should be posted in the queries one. My bad

 

[vbaInet]

You should have deleted one