Populating a "Text" field in a Report

[RuralGuy]

Open the Report in design view and then press <ALT> F11
Paste the code in there.

[two_smooth]

Open the Report in design view and then press <ALT> F11
Paste the code in there.

RG,

I'm totally lost now. I've attached a zip file of the DB. Thanks for all of your help.

two_smooth

[ConneXionLost]

Hi two_smooth,

RuralGuy's function is in the right place and working fine. The problem exists in the table. Despite the fact you have the default values set to "0" for your GradePoints fields, it appears that you've removed the zeros from many of the fields and left them as null. As RuralGuy alluded to earlier, numeric/arithmetic operations don't work well with nulls.

Probably the easiest solution for you now is to go to your report and change the formula for your "Total Accumulated Points" textbox from this:

=[6thGradePoints]+[7thGradePoints]+[8thGradePoints]+[9thGradePoints]+[10thGradePoints]+[11thGradePoints]+[12thGradePoints]

to this:

=Nz([6thGradePoints])+Nz([7thGradePoints])+Nz([8thGradePoints])+Nz([9thGradePoints])+Nz([10thGradePoints])+Nz([11thGradePoints])+Nz([12thGradePoints])

The Nz function will return a zero in place of a null and allow your arithmetic to continue.

Cheers,

[two_smooth]

RG,

THANKS so MUCH for your help and support, it is very much appreicated.

two_smooth

[RuralGuy]

You're welcome but don't forget ConneXionLost! We both helped.

[two_smooth]

ConneXionLost,

My BAD, thanks for your help and support too!!!

two_smooth

Don't Count the Dats, Make the Days Count!