Problems with MS Query -
12-29-2004
, 02:21 AM
Hi There
I have big problem with MS Query. I'm using
MS SQL MSDE (sometimes Access files) engine as warehouse. I created
ODBC data source. To create OLAP cubes I'm using MS Query.
It's nice tool for my needs. I have four aggregating functions:
- Min
- Max
- Count
- Sum
It's working without Sum. When I try to use Sum function
I receive:
"There is no possibility to write this module. Change definition
of this module and try again. If you are updating existed modules file
ensure that file is not used by Excel or other applications."
Does anobody help me in that issue?
Regards
sajdor |