VCE Stuff > VCE Computing: Data Analytics

Database SAC

(1/1)

cobby:
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 :)

danieltennis:
Yes, I would like to know too.

kurrymuncher:
ask toigo lol

Kairubin:
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]

Navigation

[0] Message Index