Hi, Posting here for the first time. I wasn't able to locate what I was looking for.
I have 2 tables
Inbound table: Inbound Item from Manufacture
Outbound table: Orders from customer.
I need to be able to provide customers with expected fill dates based on their order type and order date, corresponding to our receipt dates.
I was able to do this in excel. using running sum and Xlookup. it is too slow to do it in excel. also Excel data I am working with is snap shot in time. (day behind)
with access I can connect to live data base and obtain the information I need.
I tried to use running sum in Access with Dsum() Function I keep getting an error.
I have attached my Sample DB and Sample Excel results I am looking for.
I would really appreciate if anyone can provide me the necessary queries or point me in the right directions.
Thanks
I have 2 tables
Inbound table: Inbound Item from Manufacture
Outbound table: Orders from customer.
I need to be able to provide customers with expected fill dates based on their order type and order date, corresponding to our receipt dates.
I was able to do this in excel. using running sum and Xlookup. it is too slow to do it in excel. also Excel data I am working with is snap shot in time. (day behind)
with access I can connect to live data base and obtain the information I need.
I tried to use running sum in Access with Dsum() Function I keep getting an error.
I have attached my Sample DB and Sample Excel results I am looking for.
I would really appreciate if anyone can provide me the necessary queries or point me in the right directions.
Thanks
Attachments
Last edited: