Search results

boblarson, that was EXACTLY what I wanted to accomplish. I created the tables and when I ran the form wizard on the header table, the form automatically added the subform to capture the data exactly as required. I tested it and it works beautifully. I figured it was simple but I am no expert...

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...

Thanks, EternalMyrtle. I am planning on having a form with a sub-form for data entry but wanted to make sure that the database is designed to support that functionality. I will develop the tables as you suggest and try to figure out the entry form from there. I'll probably be posting on the...

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)...

Thanks, plog! I used the following statement successfully to get the results I needed: WHERE REF_Calendar.Date=Date()- IIF(WEEKDAY(DATE()-1)=1,3,1) I appreciate the guidance! cparaske

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. :)