Quick Question about a Query result

[cbende2]

Hello all,

When my query returns the results, I would like for the "Totals" row to be opened automatically instead of having to click "Totals" in the ribbon.
Is there a macro or SQL for after opening up the query that it automatically displays the "Totals" row?

[June7]

No code that I know of. Save the query after clicking Totals in the ribbon.

Is this a dynamic parameterized query?

Users should not work directly with tables and queries, just forms and reports.

[cbende2]

Saving the query does nothing after opening again the totals are gone

Well it's a crosstab query.

And I can't use a report for what I'm trying to display because the data in the crosstab query could change, therefor that would require creating a new report with the new data.

[June7]

Oh, saving a normal query with the Totals row works. Apparently, VBA to invoke the Totals row on a table or query involves editing QueryDefs. https://social.msdn.microsoft.com/Fo...orum=accessdev

Building a report to run perpetually based on CROSSTAB is difficult, as you noted, but not impossible. Review http://allenbrowne.com/ser-67.html#ColHead

Another alternative is VBA code and temp table.

[cbende2]

Thanks, I'll check out the references and get back to ya.

[cbende2]

Hmmm, after looking through both sources, I'm really not seeing what I'm trying to do. The first source's person has the same question as me, but he doesn't seem to get an answer for it either.

Thanks for the help June7

[June7]

The first source does not indicate if it concerns a CROSSTAB and the only programmatic solution suggested was to modify QueryDefs. However, if it was not a CROSSTAB, user should have been able to save the query with the Totals row setting.

Since I don't know your data, can't say if Allen's approach could be applied.

That leaves VBA and temp table.

[cbende2]

Yeah, VBA may be the only way to go. I'm checking out for the day, carry on the discussion tomorrow, hope you have a great rest of the day!