P
Paolo
Hallo to everybody!
have you already experienced the problem that a field with the formula "=Avg([fieldname])" inserted into a report in Access2003 generates an empty line when exported to Excel, i.e. it is not taken into account at all? However, the same operation with the formula "=Sum([fieldname])" functions perfectly.
Note: the fields I refer to are obviously numerical fields, and the report is ok in Access. I know that the same problem was present in Access2000 also with the Sum formula, that's the reason why I migrated to Access2003, but it seems the problem is only half solved.
Thanks in Advance,
Paolo
have you already experienced the problem that a field with the formula "=Avg([fieldname])" inserted into a report in Access2003 generates an empty line when exported to Excel, i.e. it is not taken into account at all? However, the same operation with the formula "=Sum([fieldname])" functions perfectly.
Note: the fields I refer to are obviously numerical fields, and the report is ok in Access. I know that the same problem was present in Access2000 also with the Sum formula, that's the reason why I migrated to Access2003, but it seems the problem is only half solved.
Thanks in Advance,
Paolo