Using Average with char fields

[Former Member]

Greetings,

I created a report  and I want to get the average for some database fields .

The type of these fields is char .How can I get the average?

Thanks and regards,

Noor Asd

[Former Member]

Hi,

Well, one way would be to leave the aggregate function on your SELECT statement and calculate the average value yourself within a loop...

Cheers,

Manu.

[Former Member]

since average is based on a numerical value, you're not doing to do it with char fields.

[Former Member]

Hi,

You have to move the values into a numerical variable before trying to average it.

Regards,

Karl