Solved Getting an average for a week

[Gasman]

I am having a bit of a mental block here.

I am trying to show the average Carbs intake over a week.
I have the data summarised daily and weekly, and that data is in qryDailyCalc and qryWeeklyCalc.

I am trying to get an average for the week to show in the Weekly form frmWeekly which is run from form frmDailyEntry and it's Weekly button.

However in my attempts I either get an average of carbs for each record, or the total for a week?

So I am asking for a little help please.

 

[Gasman]

Solved by creating another query and linking by weeknum. Could not work out how to do it otherwise.