I am trying to sum columns in a rep

[kimtp]

I am trying to sum columns in a report and have done so successfully with one column which happens to be a sum of three of these columns. In the other columns I get the 'datatype mismatch in function object {nameofobject} msgbox.

If I am summing numbers as they are defined in the database, where is this error coming from?

Thanx for the help.

Kim

 

[Darrylles]

Hi,

Do you have any null values in these columns, i.e. no value?

If so, you need to check and replace nulls with zeros.

Regards.

Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk

 

[kimtp]

Thanx. The database had all '0' but my query had something like this: IIF(RS.Num=0,'',RS,Num). Changed the '' to Null and Voila.

Many thanx.

Kim