Thread: Help with a form
12-21-06, 01:56 #1Registered User
- Join Date
- Nov 2006
Unanswered: Help with a form
I have part of a form I need help with. This is a sub form to another form. The second line (gasCPU etc.) are general fuel costs that I would input when the price changes. Step and fuel come from a table of different processes. When I pick a step to use I want the fuel associated with that to be automatically entered into the fuel box which I can’t get it to do right now. Time is the time it takes for the process which I would enter in hours and minutes. Cost needs to be time times the cost of the particular fuel. There are many steps to each job. Total time is the sum of all the times and total cost is the sum of all costs. I’m not sure how to enter in all the formulas and calculations and where they should go. I have attached a file of that part of the form.
12-21-06, 05:11 #2Registered User
- Join Date
- Oct 2002
- Leicester - UK
I'm afraid i don't have the time at the minute to help in any detail but i think i can point you in the right direction. Set a update or append query to run when you set the fuel in the main formDefinition of a Beginner, Someone who doesn't know the rules.
Definition of an Expert, Someone who knows when to ignore the rules.