H
Haim Beyhan
I'm using Access XP with SQL Server database.
I have a view with a sum query.
select colA, sum(colB), sum(colC) group by colA
colB is integer and colC is decimal(7,3)
I created a form/report and used this view as the recordsource. I changed
the format of colB to standard with 2 decimal places and colC to standard
with 3 decimal places. Although I see the colB as expected, I don't see colC
as standard format.
eg. I see 1234.567 instead of 1,234.567
I have other views also that have sum columns and the problem is the same in
the reports also.
I think the problem is only with decimal data type and only when I sum the
values. If I use instead float, real, money I don't have this problem. But I
need to use decimal.
Your help will be much appreciated.
Thanks in advance,
Haim Beyhan
haimb@remove_enigma.com (remove remove_ in order to send mail directly)
I have a view with a sum query.
select colA, sum(colB), sum(colC) group by colA
colB is integer and colC is decimal(7,3)
I created a form/report and used this view as the recordsource. I changed
the format of colB to standard with 2 decimal places and colC to standard
with 3 decimal places. Although I see the colB as expected, I don't see colC
as standard format.
eg. I see 1234.567 instead of 1,234.567
I have other views also that have sum columns and the problem is the same in
the reports also.
I think the problem is only with decimal data type and only when I sum the
values. If I use instead float, real, money I don't have this problem. But I
need to use decimal.
Your help will be much appreciated.
Thanks in advance,
Haim Beyhan
haimb@remove_enigma.com (remove remove_ in order to send mail directly)