have attached a sample db.
if you look at the table [tblFinal]
I need to create a report from that table- that displays like rptTest-but that works-
I created a crosstab query to create this report- but not sure this is how to do this-
in rptTest- i have a total field that is empty
i need a total field column to total all the weeks totals for each record.
and am trying to capture 1 week of data in report-