Search results

Hi, I am trying to develop a DB that tracks the number of packages we receive by type every day. The current database we have has the following fields on a single table: Date Location TypeA_Qty TypeB_Qty TypeC_Qty TypeD_Qty In the current structure, the person enters the date and location...

Hi, We have two facilities that receive four different types of shipments. I wanted to set up a database to track these shipments. Is there a way for me to set up tables such that the person entering the information can leverage the same date and location field for each entry type? For...

Our production database holds eight weeks of historical information that get updated in real time. I use an access database to retain a true historical record beyond the eight weeks available in production for each day. I have a very convoluted way of maintaining the historical information: 1)...

Hi, I provide a daily report to my warehouse team that pulls information from a data table for the previous day's activities. Since we don't work on the weekends, my statement needs to be manually modified on Mondays to pull the information from Friday and not from Sunday: WHERE...

Hi! I'm in the private sector in Chicago, USA and mostly work with Excel. On my current project I am leveraging Access like never before. I am looking forward to learning and sharing experiences working with Access with others in the forum. :)