All right, I give up! I'm trying to run a query(s) that will return data and perform calculations based on the criteria >=[Forms]![My_Form]![Date_In1] and <=[Forms]![My_Form]![Date_Out1]. This returns values for Starts and Hours on a particular piece of equipment (which will essentially tell when the product should be repaired/replaced). We'll call this a sprocket (Spacely brand, of course). This part works great.
Now here's my question. How can I make all this (see below) work in a reasonable # of steps? Due to the fact that each sprocket has three cycles (Date_In1, Date_In2, Date_In3), there are 16 different sprockets (S/N's A1, A2, A3...), and also a large collection of other equipment (Cogs, Widgets, etc...) I figure I need 3 queries for each piece of equipment (3 for Sprockets, 3 for Cogs...). And I would still need more based on some other equations I would need to run for these products.
So the simplest (and most time intensive) way I see of doing this is to create a query for each cycle for each piece of equipment. Now, of course, I will never do this as I'd be dead before such an undertaking was completed.
I realize this is extremely open-ended and sounds like perhaps the most mind-numbing economics class in history, but any help would be of great use. BTW, I can live without this, it'd be more of a time-saver than anything.
Thx,
Dave
Now here's my question. How can I make all this (see below) work in a reasonable # of steps? Due to the fact that each sprocket has three cycles (Date_In1, Date_In2, Date_In3), there are 16 different sprockets (S/N's A1, A2, A3...), and also a large collection of other equipment (Cogs, Widgets, etc...) I figure I need 3 queries for each piece of equipment (3 for Sprockets, 3 for Cogs...). And I would still need more based on some other equations I would need to run for these products.
So the simplest (and most time intensive) way I see of doing this is to create a query for each cycle for each piece of equipment. Now, of course, I will never do this as I'd be dead before such an undertaking was completed.
I realize this is extremely open-ended and sounds like perhaps the most mind-numbing economics class in history, but any help would be of great use. BTW, I can live without this, it'd be more of a time-saver than anything.
Thx,
Dave