Doing calculations on a data report?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • THEAF
    New Member
    • Mar 2007
    • 52

    Doing calculations on a data report?

    hi
    im trying to produce a data report for my computing project.
    the data report shows information on an examiner such as name & address.
    It also shows the number of scripts that examiner has marked for a perticular subject. A script per subject has a fixed payment
    i.e Maths = £2.50 , English = £4.20. This I call Script rate.

    what im trying to do is when the report opens for a particular examiner, showing the number of scripts they have marked for maybe just english and maths and along with it showing the script rate.
    I will need a box or something on the report where it will show the result from the scripts being multiplied to the script rate giving me a total. Then if that examier's tax deduction is true (if taxhas to be deducted form their payment or not) then 22% should be deducted form the final payment that will be made to him for the work.

    i hope you can understand this and have an answer to it.
    i have done some coding for the data report to open and show some of the data.
    i will happily except any answers and ii will try to adapt it to my use.
  • Dököll
    Recognized Expert Top Contributor
    • Nov 2006
    • 2379

    #2
    Originally posted by THEAF
    hi
    im trying to produce a data report for my computing project.
    the data report shows information on an examiner such as name & address.
    It also shows the number of scripts that examiner has marked for a perticular subject. A script per subject has a fixed payment
    i.e Maths = £2.50 , English = £4.20. This I call Script rate.

    what im trying to do is when the report opens for a particular examiner, showing the number of scripts they have marked for maybe just english and maths and along with it showing the script rate.
    I will need a box or something on the report where it will show the result from the scripts being multiplied to the script rate giving me a total. Then if that examier's tax deduction is true (if taxhas to be deducted form their payment or not) then 22% should be deducted form the final payment that will be made to him for the work.

    i hope you can understand this and have an answer to it.
    i have done some coding for the data report to open and show some of the data.
    i will happily except any answers and ii will try to adapt it to my use.
    Hello, THEAF!

    Where are you getting the data from to create the report?

    I am assuming you are using VB as front end. Can you tell us the version?

    Please stay tuned, you will get the help needed.

    Dököll

    Comment

    • THEAF
      New Member
      • Mar 2007
      • 52

      #3
      im continuing from the last post i had. And i found the solution to that problem to. My mate showed me. just had to add an 'adstateopen' an a few things.
      im just continuing form that same work. Im trying to create a payslip that will show all the scripts he/she has marked and then shows the total payment that will be given to them. this sounds a bit iffy i Know. just tel me what you don't understand.

      Comment

      Working...