Results 1 to 2 of 2

Thread: total in report

  1. #1
    Join Date
    Jul 2012
    Posts
    1

    Unanswered: total in report

    i already have total at my form.then i need to print report with the total.i do that n its work but the total show mny times with same total..
    like this:

    total balance i use this formula for total balance
    90 nz([quantity in]-nz[quantity out])= bal
    90 then sum([bal]+[opening])=totala balance
    90
    n so on....

    i have total this material, i give u one example of my material

    part name opening in out total balance date in date out
    ms roil coil 100 10 50 60 1/07/12 4/07/12
    ms roil coil 50 20 90 5/07/12 7/07/12

    n i want my report just show last date with total 90 only.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    you either need to replicate the formula or do a bit of processing in background using VBA.
    for me I'd go the VBA route {in part becuase I really am a jaded developer and like to tinker with code , but also becuase it offers more flexibility}
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •