Calculating Average Order Lifespan based on Previous Order Received Date

Thursday, May 12, 2022
10:00 AM

Hello!

I am creating a database to manage multiple households.

The problem I am running into is measuring Average life of an item.

I am currently trying to use 3 tables to fix this. I have table {Supplies} where I have my item records, {Log} which keeps track of weekly inventory checks, and {Orders} which records orders placed for this item.

In the {Log} table I have a different record for checking each of the items in my household, I group them by Check Date. In {Orders} I group the items that are ordered together. And am manually entering Date Ordered and Date Received.

My problem is that I can’t seem to find a way to calculate days elapsed since the previous order for each entry in the {Log} without manually entering the date of the previously received order for this item.

I think I need to find a way for the Previous Order Received Date the records in the {Log} table to stop updating so that I can measure Days Elapsed on that record. (DateTime_Diff (Previous Order Received Date-Date Ordered))

I’d really appreciate some help on this.

Thanks!

Hey Gee, I’m having a bit of a hard time wrapping my head around this. If you can post some screenshots and example data or a link to an example base, as well as the specific output you want I’ll see what I can do

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.