Trying to take the average of a function

[mrr2]

is not fun. Can someone please help me reign this one in please?

I am trying to take the difference of H0A0 and 10Yields and then create a new row that calculates the average of all of the variances in my series.

Is that possible?

Here is where I am stumped

SELECT tbl_10yr_monthly.period, tbl_10yr_monthly.px_last AS 10Yields, tbl_H0A0_monthly.px_last AS H0A0, [H0A0] - [10Yields] AS Spreads, AVG(Spreads) As Average
FROM  tbl_10YR_monthly, tbl_H0A0_monthly

[June7]

No, the query cannot place the average in a new row.

Avg is an aggregate function and can be used by:

1. table, query, form in Datasheet view, select Totals from the ribbon which will open a row at bottom of the object offering aggregate functions under each field

2. in GROUP BY (totals) query

3. in report using Grouping & Sorting with summary calcs in header/footer sections allowing display of detail records as well as the aggregate calcs

[mrr2]

Ok thanks June7, I am thinking of creating a intermediary table that calculates the average first, and referencing it in my final query to get the result I am looking for..
THanks again -