Search results

Here is what I have: tblPerformance [ProdDate],[Press],[Changeover] 3/3/2013 4:14:36 AM Kase 1 2 3/3/2013 4:14:49 AM Kase 2 3 3/4/2013 6:15:23 AM Kase 1 4 3/4/2013 6:16:16 AM Kase 2 3 *Note* I have to use the time because our plant considers a day from 7am -...

Is it possible to change that time at which the auto date changes to the next day? For instance, I have a form with a date box and I am using =Date() to auto populate the field. I need that date to change over at 7am rather than 12am. Is this possible and if so how??? THANKS!!!!

Thanks in advance!!!! Here is what I have: tblOrders [Press][Shift][TotParts] Example: [Press1][A][5000] [Press1][B][3000] [Press2][A][2000] [Press3][A][4000] [Press3][B][3000] Here is what I need: A query that will return the total produced between the shifts by press... Example...

Here's what I have: tblOperatorAssignments [Date], [Shift], [Press], [Operator] frmOperatorAssignments I need to be able to enter all operators and presses as individual records in the table so it would look something like this: [Date] [Shift] [Press](Default "1") [Operator]...

What I have: 2 tables tblMaterialNo with fields ID, MaterialNo, MatDes tblColorData with fields ID, MaterialNo, ColorNo, ColorDesc WHAT I NEED: I need to create a form that with allow the user to select the material number from a combo box I created using the table as the source, and have...

So I don't even know where to begin on this one so I figured I would go ahead and post to see what you folks may know about it! Here we go... What I Have: I have an excel table that provides product part numbers, Description, The components within the part number and the component part...

Hello all! I use this forum a lot for getting my questions answered but this is the first time I am asking myself. I have been a long time excel user and I am new to Access. I have started a database and what I need it to do is simple I'm sure but I'm at a brick wall with it! :banghead: Here...