Query Based On Zero Value and 30 days From Todays Date

[NYFashionToGo]

I have a series of queries that Build an inventory Count for me. It basically tells me How much I have in Stock, Whats in Shipping and does the math. One thing that I do not have it doing is eliminating 0 quantity (On hand Items) I realize it is easy to set the criteria to zero, But I would like to put a delay of 30 days before it comes off the list.... So Basically 30 days from todays date If this number is 0 take off the list. How do I write a query to do this?

Thanks

 

[SkipVought]

Hi,

...
Where On-Hand                                   =0
  And [b]The_Transaction-Date-That-Changed-On-Hand[/b] =Date()+30

Do you have The_Transaction-Date-That-Changed-On-Hand?

Skip,

_[red][/red]

 

[NYFashionToGo]

No I dont have that In the query Directly, However I do have it someplace else. which I probably can get into the this query....

That creates another query issue (That I do not know how to do) How do I determine only the last sales transition date. Otherwise they would all pop up in the query.

 

[SkipVought]

MAX([The-Date])

Skip,

_[red][/red]

 

[NYFashionToGo]

okay Very good. Thankyou, I will work on that. I think I see how to do it now. Thanks for the tips.....