Recent content by Guitarcam87

Maybe you can help me with another aspect now...;) What would the syntax look like if I wanted to add another field to the mix. Or is this even possible?

Perfect thankyou!!!!!!

I got the following error message... "You tried to execute a query that does not include the specified expression 'DateValue(tblPerformance.[ProdDate])' as part of an aggregate function.

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

That worked perfectly however now I am trying to do a query and it will not return anything... The date is showing up as 2/27/2013 4:54:52 AM which is correct and fine In the query I need it pull only records for the current date. I try using =Date() for the criteria and I get no returns...

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

Thank you so much that worked perfectly!

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

That worked perfectly thank you!

How would I go about that?

I actually tried that. The trick is that not all the material numbers have all the components from the other tables. When I add all the other fields to the query it only returns the material number that have all the components. I'll upload the db in a bit.

I'm not sure how you would go about that trying that. Please do tell???

I actually thought about the the only trouble is this is only one portion. There are actually several tables with related info that I need to pull separately. For instance there is also a tblHandleData with the materials that have a handle. I will need a box to populate that info based on the...

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