Design help for making calculations from tables.

[NightWalker]

I have a test system that runs pressure profiles. These profiles range from 0psi to 2000psi. There is also a rate that the pressure increases and decreases. The profile has many increases and decreases as well as hold times at the target pressure. These profiles are associated with production products. I have a table already for the production products. All products have only one profile. Some profiles are used for multiple products. I am trying to be able to enter a start time and have all the times for the steps of the profile calculated. The only item needed to be recorded from the times is the start time, but on the form or report I would need to see all the times for each step of the profile that would be running. I am not sure how to build the tables that I can reference to do the calculations for the times for the different profiles.



Here is an example of a pressure profile. only the first start time would need to be saved.
For this product the pressure change rate is 100 psi/min up and down.




Thank you for any help or advice on this.
Walker

[ranman256]

is the query supposed to build all times except the 1st?
if so, is there a list of time increments ([REQD] field ) that IT would do , OR are the increments typed in? 5min, 2hr, etc...?

[NightWalker]

ranman

Thanks for your reply!!!

I was wanting to build all times after the first based on the increments of the (reqd) field. I currently do not have any of this information stored in access. I am not sure how to approach putting all the different profiles into a table setup.

[NightWalker]

I am mostly looking for ideas for a jumping off point and I will do my best to run from there. I like trying to figure out everything but this one I don't even know where to start the table structuring.

[ranman256]

you need all the test cycles and their times, then it can build cycle2 with 2 minutes. (cycle 1 means nothing)
youd have to have to breakup REQD since it cant be used in calculations, it would have to be 2 fields:
cycle, TimeInc, TimeType, Note
3, 5 , n , (5 min)
9, 2 , h , (2 Hr)

starttime = DateAdd(TimeInc,Timetype,prevTime)

[NightWalker]

ranman

Thank you for the reply. I am working on that right now for all my products. If I have multiple products that use the same test profile how would I get each product to look at their respective profile calculator.

Thank you,
Walker