ATAR Notes: Forum

VCE Stuff => VCE Technology => VCE Mathematics/Science/Technology => VCE Subjects + Help => VCE Computing: Data Analytics => Topic started by: cobby on May 25, 2009, 06:11:38 pm

Title: Database SAC
Post by: cobby on May 25, 2009, 06:11:38 pm

Hey guys,

For our SAC we have to make a report/invoice of a customers purchases.
I've made a calculated SubTotal field, and it works fine.
But when i want to make a grand total (i.e Sum of all Subtotals by a particular customer)
It makes an overall total of all purchases.

ALSO, when i place the calculated field in page footer of the report in design view, it comes up as '#error'
We are required to make a profit query aswell, which i do not know how to make
Does anyone know how this can be fixed or made??

Thanks :)

Title: Re: Database SAC
Post by: danieltennis on May 25, 2009, 07:53:10 pm

Yes, I would like to know too.

Title: Re: Database SAC
Post by: kurrymuncher on May 25, 2009, 10:52:07 pm

ask toigo lol

Title: Re: Database SAC
Post by: Kairubin on June 02, 2009, 11:44:15 pm

On the report itself. (Don't remember been a while)
There is and option to pull down a erm. label i think =|
then just go =[name of your subtotal]+[others]