Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Equipment Maintenance Query
Sorry. I was working on multiple queries yesterday and forgot that was in there. Thanks for the information!! -
Equipment Maintenance Query
I am trying to write a query to display any equipment that is due to be sent in for yearly maintenance. It should run off of the creation date of the equipment entry if it hasn't been sent in before. If it has been sent in, it needs to run off of the closed date of our service call. I created... -
Query - ONLY inventory that hasn't moved in past 90 days
So far, so good!!! Thank you!! -
Query - ONLY inventory that hasn't moved in past 90 days
I need to determine which inventory items we currently have in stock that have not moved in the past 90 days so we can try and use them up. I am trying to look at all line items on an invoice within the past 90 days, but only include all of the items that do NOT show up on these invoices...
