E
Elizabeth Swoope
I have created a crosstab with ProjNo (text) as the rows, ExpObj (text) as
the columns, and the sum of Amount. I can use the property sheet to format
the overall total for each ProjNo as Standard 2, but the total for each
ExpObj within ProjNo is in general format no matter what I do (regardless of
the field properties in the original table, formatting in the original table,
formatting in the underlying query, and formatting in the crosstab query).
In the original data table (tblLedger), I have tried Amount as double,
formatted as Standard 2. I have also tried it as Decimal with Precision 18,
Scale 2, and Dec 2 (formatted as Standard 2, Fixed 2, and Currency 2).
The crosstab query is based on a query on the data table and Amount is
correctly formatted in the query.
I am obviously doing something wrong! Do I have to somehow use a function to
format these numbers? Having money amounts with different numbers of decimal
places is unacceptable.
Thanks,
liz
the columns, and the sum of Amount. I can use the property sheet to format
the overall total for each ProjNo as Standard 2, but the total for each
ExpObj within ProjNo is in general format no matter what I do (regardless of
the field properties in the original table, formatting in the original table,
formatting in the underlying query, and formatting in the crosstab query).
In the original data table (tblLedger), I have tried Amount as double,
formatted as Standard 2. I have also tried it as Decimal with Precision 18,
Scale 2, and Dec 2 (formatted as Standard 2, Fixed 2, and Currency 2).
The crosstab query is based on a query on the data table and Amount is
correctly formatted in the query.
I am obviously doing something wrong! Do I have to somehow use a function to
format these numbers? Having money amounts with different numbers of decimal
places is unacceptable.
Thanks,
liz