Reports In Access How do I use VBA

[Neak1]

Hello Everyone,

I have an Access Report with 3 fields Name,Code,and Amount fields. I need to generate totals at the end of the report if some conditions are met. For example: if the code field is equal to A then sum all the amounts in the amount field and display the totals at the end of the report. There are 6 different codes and I need to be able to calculate total amounts for each code within the report.

If anyone can help me then it would be greatly appreciated.

Neak1

 

[TheDOG]

Search for "If...then...else" in Access help.

 

[derrick]

Use queries to generate your totals then insert the results in your report.