Login

Search the forums now!

Welcome, Guest. Please login or register.

September 28, 2025, 12:58:48 pm
Pages: [1]   Go Down

Author Topic: Database SAC  (Read 1271 times)  Share 

0 Members and 1 Guest are viewing this topic.

cobby

  • Victorian
  • Part of the furniture
  • *****
  • Posts: 1437
  • Respect: +7
Database SAC
« on: May 25, 2009, 06:11:38 pm »
0
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 :)
Logged
2008 - Economics
2009 - Maths Methods CAS
          English
          I.T Apps
          P.E

danieltennis

  • Guest
Re: Database SAC
« Reply #1 on: May 25, 2009, 07:53:10 pm »
0
Yes, I would like to know too.
Logged

kurrymuncher

  • Guest
Re: Database SAC
« Reply #2 on: May 25, 2009, 10:52:07 pm »
0
ask toigo lol
Logged

Kairubin

  • Guest
Re: Database SAC
« Reply #3 on: June 02, 2009, 11:44:15 pm »
0
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]
Logged
Pages: [1]   Go Up