Method:Classic General Q&A

Re: Report, dividing the total amount due

John M — Wed, 03 Aug 2011 14:35:57 GMT

Greetings,

Rats! i did not know about the right click thing on the table designer. I tried it and it was so quick. Just like using excel or access. One of these days i will have to break out the manual on this. Thanks guys

Re: Report, dividing the total amount due

Method_Paul — Wed, 03 Aug 2011 13:50:20 GMT

John M,

One thing I'll add to this (since there are other non script people reading this that we don't want to freek out!) is that before resorting to VB script, you can always try to accomplish your calculations using Calculated Fields. You can right-click on a table in the designer and add a calculated field, and then drag that calculated field onto the report. It will often accomplish what your VB script does, but using a much easier to use wizard.

Paul

Re: Report, dividing the total amount due

Method_Michael — Wed, 03 Aug 2011 13:35:46 GMT

Great job! Having a bit of VB knowledge does come in handy when working with the scripts in the report designer.

-Michael

Re: Report, dividing the total amount due

John M — Tue, 02 Aug 2011 23:35:36 GMT

Thank goodness i did not throw out my old VB books. They were really dusty.

label5.text = xrLabel39.text \ 12

There is the script. Works great. I want my future customers to know what the monthly cost will be for their gardening service.

Report, dividing the total amount due

John M — Tue, 02 Aug 2011 21:32:07 GMT

Greetings,

Im taking the simple estimate report and i want to divide the AmountTotal field and divide that by 12. I want to get a monthly amount in a new field.

Anyhelp?

Thanks, John M