Calcuating Values Pt/2

[WhatnThe]

I have one last question which is my last real hurdle with this database. I am going to attach a demo of the database in question. RuralGuy has helped me get this far, now I would like to know if it would be possible to do multiple calculate using the code he provided.



I mean with his code we are calculating the total PcsProduced based on the legenths*PPL. fields

I need to be able to calculate hours earned based on the PcsProduced field
this is calculated by taking the PcsProduced / SpecSPM that will = Hours Earned

I also need to calculate the Standard Hours. To calculate this I would take the Number Machine Run / 480 / 60

Basically I need to calculate multiple values, based on other calculated values. Possible?

[Rainlover]

Can't help. I only have 2003.

[WhatnThe]

Its ok Rainlover I have just figured it out for myself. If anyone would like to know how I what I did just ask. If you would like me to upload a 2003 sample for you I will. I can send it prior to the changes I am currently making to it.

I do have a question for you Rainlover. If I wanted to calculate of a form field could this be done though a query.

[Rainlover]

>> do have a question for you Rainlover. If I wanted to calculate of a form field could this be done though a query. <<

You can use a Query to calculate most things and update a Table. But it will not update the Table unless it is an update query. And then you cannot use and update query to view data.