A
apollo8359
I have a simple table with a column of numbers using the standard format with
no decimals. In the table I see commas in four digit numbers, as expected.
When I use this table in a Crosstab query I suspect Access changes these
numbers to text because I lose the comma and I can not add up the values on
my form. The crosstab properly totals the numbers by every month, so I get
twelve columns of what look like numbers (no commas but they hug the right
side of the column) for twenty rows. Using a continous form for the twenty
rows I need to display, the data is displayed nicely, however, it becomes
obvious that you need a row total and a column total on the form. After
reading through some postings, I decided to do the row totals in the query,
which works fine now. However, the column totals, in the footer, appear to be
referencing text as I can only get the first value, (row one) to display. The
control at the bottom of each column is =Sum([Jan]) and so on for each month;
what is displayed is the value in row one. The field in the query is set to
value and sum, so I can't see where it is being converted to text, if that is
the problem. Anyway, what is the prefered method for adding up a column of
numbers generated by a crosstab query for display in the footer of a form?
Thanks
Michael
no decimals. In the table I see commas in four digit numbers, as expected.
When I use this table in a Crosstab query I suspect Access changes these
numbers to text because I lose the comma and I can not add up the values on
my form. The crosstab properly totals the numbers by every month, so I get
twelve columns of what look like numbers (no commas but they hug the right
side of the column) for twenty rows. Using a continous form for the twenty
rows I need to display, the data is displayed nicely, however, it becomes
obvious that you need a row total and a column total on the form. After
reading through some postings, I decided to do the row totals in the query,
which works fine now. However, the column totals, in the footer, appear to be
referencing text as I can only get the first value, (row one) to display. The
control at the bottom of each column is =Sum([Jan]) and so on for each month;
what is displayed is the value in row one. The field in the query is set to
value and sum, so I can't see where it is being converted to text, if that is
the problem. Anyway, what is the prefered method for adding up a column of
numbers generated by a crosstab query for display in the footer of a form?
Thanks
Michael