Cannot add more than 3 columns in AWA datasheet view

[alissb]

Hi. This is for an access web app. I have a datasheet view from a query that lists count totals grouped by category and there are 6 columns of totals by different types (sort of like a cross-tab work around). I can add a Total text box to the view and add the columns in the data control source for that new Total column.
It limits to adding 3 columns and it displays #REF if I go over 3.
The Sum() does not work.
Is there another way?
thx!

 

[Ranman256]

sum the columns individually, post to a 'report' table.

 

[alissb]

I am not sure I understand. Currently I am adding separately and it works perfectly up to 3 items, but it won't let me add more than 3.
This is the data control source from the datasheet view for a column I added.
So this works: (A,B & C are columns I want to add)
----------------------------X
DATA
Control Name Total
Control Source =A+B+C
------------------------------

But this doesn't work:
-------------------------------X
DATA
Control Name Total
Control Source =A+B+C+D
---------------------------------

 

[alissb]

OK, I was able to create a total column in the query, but still curious why the limit in the control in the datasheet is to only be able to add 3 things. I only wanted this for the view, but will use the query. (this is referring to the web app not desktop).