Need to calculate a number of values and display values to user

[jpstokes]

I'm working a project where I need to calculate the EVM for each project in the db. I need to query a table for the values I need and do some calculation with the values then display these values. I'm thinking I should be able to use a listbox for display if I could figure out how to gather all the data I need and calculate the values.

The challenging part is I have to perform 14 different calculations for each project. So my question is how do I do this when I have to perform a different query for each calculation?

[Rabbit]

It would help to know what the calculations are that you need to do.

[jpstokes]

I listed a few examples below:

• sum all estimated cost for each tasks included in project
• sum all the actual cost for each task included in project

Projects are in one table and Tasks in another.

[Rabbit]

You can do multiple sums in one aggregate query.

[Mihail]

Are you SURE that you need DIFFERENT calculations ?

Maybe you can design some general formulas.
Say you have 3 properties (fields) for the general project (a, b and c) and 2 formulas like F(a,b,c) = a + b + c and G(a,b,c) = a*b

Now say that project 1 has all fields completed.
So you can compute F1(a,b,c) and G1(a,b,c) with (true) results.

If project 2 has only 2 properties (a and b) the property c exist but will be null. In this case you still can compute both formulas F2(a,b,c) and G2(a,b,c). For G you obtain a (true) result but for F you obtain NULL.

Hope you understand the idea and the top question of my post.

Good luck !

[NeoPa]

If you haven't read any of the threads posted to explain how to ask questions that someone can answer then you should consider :

1. Listing the tables involved in your data.
2. Listing the fields in the tables involved in your data.
3. Indicating what the calculations are you need performed.

Simply saying you have some calculations to perform on some data and asking for help is not going to make it easy for anyone to help you. Asking questions clearly isn't rocket science.

[jpstokes]

Created new topic for this question. with better explanation of what I need. ;-)

How to insert computed value in listbox on a per item basis

[NeoPa]

We don't normally encourage reposting of questions, but in view of the effort you've put into that, and how you've taken what was said on board, I'll leave this thread here (locked - so no further conversation on the problem is kept away from the better explained question in the other thread), still available to view and link across from.