Re: difficult problem

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Duane Hookom (duanehookom_at_NO_SPAMhotmail.com)
Date: 03/21/04 

Date: Sun, 21 Mar 2004 14:18:00 -0600

Where is the "calculated field total price" or whatever that you want to sum
in the report footer? I expect that you need to set a running sum on
payments in the payment header but you haven't provided enough information
regarding your fields. 

-- 
Duane Hookom
MS Access MVP
"fedum" <anonymous@discussions.microsoft.com> wrote in message
news:1117801c40f40$9c6e89b0$a101280a@phx.gbl...
> Report with group sections. First section is a header from
> the field PAYMENT (cash, visa, mastercard ..) then a
> second header from the field TICKETID and next DETAILS. In
> these details are sales with the pieces, price, reduction
> for each articles that has been sold on this ticket.
> My problem: I would like to make the sum for each payment
> from the calculated field total price, reduction in the
> report footer.  But when I have more then one article on
> the ticket than the sum reduction  will be made for as
> much sales on each ticket. Ex. I have 3 articles on 1
> ticket with only for 1 articles a reduction, well he takes
> this reduction 3 times. Also when I make a sub report.
>

Relevant Pages

  • Re: report totals
    ... on the leases given to the employees of the various companies. ... leases promised to a company and totals leases actually used by the company) ... I would like to sum the total number of parking spaces ... Put a text box in the Report Footer and use an expression in Properties ...
    (microsoft.public.access.reports)
  • Re: Report Formula
    ... formula is placed into the report footer it calculates to £7. ... However the problem is that it now rounds up ... I only want the SUM total to round up to £10. ... >> the field needs to ...
    (microsoft.public.access.reports)
  • RE: Profit/Loss Calculation in Subreport
    ... learned that Access can't sum a sum (much unlike Excel...I'm very good with ... I have tables for the following: Project Cost Main, Project Cost Detail, ... any accessories, etc.), A/R, Cost of Goods, A/P, Labor to prep machine for ... Did you put this in a text box in a group or report footer section? ...
    (microsoft.public.access.reports)
  • F.A.O. - Fons Ponsioen
    ... Shown below is the continuation of the post: ... >the report footer ... However the problem is that it now rounds up ... I only want the SUM total to round up to £10. ...
    (microsoft.public.access.reports)
  • Re: Proposition for Nick (open): Why so little parallelism?
    ... |>> Don't assume that you are going to have all the elements of your sum ... It is very rare indeed for a simple reduction to be worth parallelising; ... the usual reason for doing it is that it is easy ('low hanging fruit'). ...
    (comp.arch)