Using Avg on results of four seperate queries

[Jay]

I am currently having an issue with syntax for the Avg function when I try to
create an expression to create an average for four seperate queries.

The queries fields are [FF Test Score][MO Test Score][LLM Score][Production
Score] which are all assoicate with one indivdual project

I want to use the Avg functions since it will exclude null values since not
every project will have all four tests performed so it needs to only average
any of scores that have a value for each project.

 

[Tom van Stiphout]

On Mon, 10 Nov 2008 16:04:00 -0800, Jay

In the subject of this message you wrote "...four separate queries",
whereas in the body it appears there is one query with four fields.
Can you shed more light on this. Precise language helps us understand
what you mean.

-Tom.
Microsoft Access MVP

 

[Jay]

The fields come from four different queries. I build four queries to
calcuate % scores based on data from the database table. Now that I have the
scores of the four different project tests I am trying to get the average
score of the four scores that come from the four seperate queries. The
queries and fields are as follows

Query 1 [FF Test Score]
Query 2 [MO Test Score]
Query 3 [LLM Score]
Query 4 [Production Score]

The issue is that each project will not always have all four tests performed
and will result in a null value in the score. So I want to use the Avg
function to get the average which would exclude the null score when it
calcuates for a project.

On Mon, 10 Nov 2008 16:04:00 -0800, Jay

In the subject of this message you wrote "...four separate queries",
whereas in the body it appears there is one query with four fields.
Can you shed more light on this. Precise language helps us understand
what you mean.

-Tom.
Microsoft Access MVP

I am currently having an issue with syntax for the Avg function when I try to
create an expression to create an average for four seperate queries.

The queries fields are [FF Test Score][MO Test Score][LLM Score][Production
Score] which are all assoicate with one indivdual project

I want to use the Avg functions since it will exclude null values since not
every project will have all four tests performed so it needs to only average
any of scores that have a value for each project.