cannot average

[Daisy_(Guest)]

Hi,____I am trying to use average in report writer but the values are incorrect for examples I want the of data in Month field of the data base in sql I would do AVG(MONTH) but I cannot do that here could some please guide me in the right direction.____Thanks__Daisy

[kfleming]

Can you give me a specific example of the list of values you are using and the number that is being generated by R&R?____Kathleen__R&R Support

[Daisy_(Guest)]

thanks that problem got solved there is one more little problem could you help me solve this. I have a field "Re" and the data inside this field is dates. What I want to do is that subtract the current date from the "RE"____Thanks for the help.____Daisy