By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,943 Members | 1,921 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,943 IT Pros & Developers. It's quick & easy.

Doing calculations on a data report?

P: 52
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.
May 2 '07 #1
Share this Question
Share on Google+
2 Replies


Dököll
Expert 100+
P: 2,364
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
May 3 '07 #2

P: 52
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.
May 3 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.