Doing calculation in access

[Johanb26]

Hi guys,



I want to implement a new feature in my access database, but I have trouble wrapping my head around how to do it.

What I want to do is create a trend and ultimately display the trend on a graph.

I am able to do it in excel with ease, but its time consuming and have no idea how to do it with my data in access.

The scenario:

I have an asset that is tested once or more per year to ensure satisfactory running condition. Then the asset results are sent back to me and entered into the access database.

Now to do a trend with the results I have to calculate the (current results - previous results) / by (days between the tests.) But I also have multiple results with mulitple date ranges. So access has to do this for the first 2 results, then the next 2 and so.

How can i set this up in my access database so I can select the date range, select the asset and access automatically does the calculation. In excel this is easy, but also very time consuming since I need to export the data from access, do a formula to determine one result from my 2 results, then do another formula to get my results from another set of results then I just take the answers to the calculation and put it on a graph and see the trend. Is something like this possible in access ?

[June7]

Don't think this will be easy.

Looks like I have time to spare this weekend. I analyse graph issues best when I can work with data. If you want to provide, follow instructions at bottom of my post.

[Johanb26]

Don't think this will be easy.

Looks like I have time to spare this weekend. I analyse graph issues best when I can work with data. If you want to provide, follow instructions at bottom of my post.

Hi June,

Thanks a lot for the assistance. I will send it for you tomorrow, but I am hoping others can also reply and provide assistance as this is something I would also like to do. Or when I send it to you if you can look at the data and explain to me how to do it ?

[June7]

Certainly, I will do my best to explain any conclusions I arrive at. That's why I am here.