Calculated Query I think?

[jstew]

I have been trying to get this thing to work for quite sometime now, but no luck. Let me explain my situation. I'm trying to create a query that lets users know when our machines need to be serviced. Here is the math behind how we determine when service should be. We first need to figure out how many machines are customers own. I'm thinking I could use a count function to count the serial numbers on the machines to determine this. We then have to ask the customers how many machines they are running simultaneously. Based on this we can now calculate when service is going to by taking 8760hrs.(total per year) and multiply by how many machines are running simultaneously. So if the count function determines that a cust. has 3 machines but they are running 2 at a time then 8760x2=17520required operating hours per year. Now we take 17520 / 3 = 5840hrs. per machine/yr. We divide by three because we come up with a schedule for the customer that keeps the machine operating hours the same. Now we need an input box or something that will let me enter a variable to determine the service schedule. For instance if it were 18,000 hrs. between schedule maintenance then take 18,000 / 5,840 hrs. per machine = 3.08 years between service. I'm a newbie at this Access stuff and am looking for someone to shed some light on this. I hope I've at least made some sense. Thanks for the help!

jstew

 

[AccessAce]

It sounds like you've got all the information you need. If you create a form that accepts the inputs you stated, then have the form perform the calculations like you want, it should give you the answer you want. Because all of the information is not coming from a table or stored data, the info will have to be input when you run the equation.
Once you get the answer, you can use an update query to save that value in a table somewhere.
I hope that makes sense.