Total bar in a Crosstab query

[djclinton15]

Hi,

Is there way for the Total bar to appear when I open up a Crosstab query? I know that when I create a Crosstab query into a form (datasheet) the total bar stays viable at all times. Can I somehow have the the total bar stays viable in a Crosstab query at all times?

Thanks in advanced!

[Micron]

I see that over in the other thread about this, someone did post an answer about this when I figured they wouldn't .
Anyway, that was going to be more or less what I was going to reply with. I have no idea what you mean by a "total bar". If you're referring to the Sigma (totals) symbol in the Show/Hide part of the Ribbon, it's only for design view. Why would you want to see that in datasheet view?

[June7]

Perhaps OP means the Sigma button on the Home tab Records section. Instead of 'Total Bar' they mean the 'Total Row' of datasheet view for a table, query, form. This row can be set on a table or SELECT query to automatically reveal when the objects open, but not on a CROSSTAB or a UNION. Have to click the Sigma again to reveal and the aggregate functions previously set will execute. Sorry, it is what it is.

[Micron]

I believe you can show the total row in a crosstab but I can't test it now. Referring to 2007 or later.

[djclinton15]

June, thanks for answering my question & no need to say sorry! It's no big deal, I was just looking for a yes or no answe

[June7]

All I did was test each query. A SELECT query saved with the Total Row revealed shows the Total Row when the query opens. This does not happen with CROSSTAB or UNION, although the previously selected functions are saved and will execute when the row is revealed. Whether this is a bug or intended behavior I can't say.

I am using 2010 and sounds like you experience the same in 2013.

[djclinton15]

Although this may not make sense to many, but I'm creating Datasheet Forms based on some of my Crosstab queries. 1) The Total Row stays revealed upon close/open. 2) I have more flexibility to manipulate data, (i.e. alignment) which one is limited with queries. Access is a "hobby" for me; I'm not into computer games, not a reader (visual learner), etc. Being quadraplegic (type with head stick/pointer), don't work, & for some reason Access just intrigues me. Learned most of Access skills from all dedicated & devoted members here on this site. It's unbelievable!

Hope not to be inappropriate in revealing oneself.

[Micron]

Hope not to be inappropriate in revealing oneself.

I don't think so, but have to say it's not relevant to me - at least not for this thread. If you needed to reveal that to explain why you're not doing something that was suggested, how much you reveal would be entirely up to you. These days, it seems many those who are afflicted don't want to be labelled by their challenges, much less call attention to them. To each their own, I guess.

As for your post, I too see that there are oddities around the query totals row for a crosstab. Even if an aggregate function is chosen, the datasheet view won't automatically show the row, but it will retain the calculation for the field when the totals button is clicked again. Perhaps this is just another reason why we say you're not really supposed to be revealing queries anyway (at least not interactive ones), rather data should be presented in forms. If you do that, a set of calculated fields on the form (usually in the footer or header) can show the calculations and will always appear unless you design or code otherwise.

[djclinton15]

Much thanks for the advice above & put things in prospective!