Group By and Grouping

[Steve]

Are the Group By clause in queries and Grouping in reports related?

Thanks!

 

[Jeff Boyce]

Both provide a way to group by.

But at least in previous versions of Access, you had to use the Grouping in
reports to get grouping in reports ... the Group By you set in your query
did not migrate to the report.

(just one person's experience)

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Steve]

Thanks for responding, Jeff!

Steve

Both provide a way to group by.

But at least in previous versions of Access, you had to use the Grouping
in reports to get grouping in reports ... the Group By you set in your
query did not migrate to the report.

(just one person's experience)

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Gina Whipp]

Steve,

Even more surprising you did not know this but offer your services????

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[John W. Vinson]

Are the Group By clause in queries and Grouping in reports related?

Thanks!

Only in that they both perform the same basic function.

A Report's Sorting and Grouping dialog is more powerful than the Group By in a
Query in that you can use it to create multiple levels of subtotals on a
Report, with group headers and footers; do note that a Report can be based on
a Totals query but it will ignore the sort order specified in the query, and
require that you specify it in the report's Sorting and Grouping.

 

[Steve]

You're nothing but a stalking bitch. You did not know this and you dare to
criticise.

Steve

 

[Steve]

Thanks for responding, John!

Steve

Only in that they both perform the same basic function.

A Report's Sorting and Grouping dialog is more powerful than the Group By
in a
Query in that you can use it to create multiple levels of subtotals on a
Report, with group headers and footers; do note that a Report can be based
on
a Totals query but it will ignore the sort order specified in the query,
and
require that you specify it in the report's Sorting and Grouping.

 

[Gina Whipp]

Steve,

Ummm... no reply neccessary as I have answered this type of question before.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Steve]

You offer no denial so that's an agreement by you!

 

[Gina Whipp]

And you can't read!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Duane Hookom]

So now we know that you:
1) continually abuse the public news groups by attempting to sell your
"services"
2) your "services" are based on a limited knowledge of queries and reporting
3) you have a potty mouth
4) you can't read

 

[Keith Wilby]

Are the Group By clause in queries and Grouping in reports related?

No. But then any developer worth their salt would know that.

 

[Keith Wilby]

You're nothing but a stalking bitch. You did not know this and you dare to
criticise.

Both false statements of course, plus Gina's "tricks and tips" are there in
all of their splendour and not "coming soon" as yours have been for years.

 

[Steve]

Still no denial so you must agree that you are nothing but a stalking
bitch!!!

 

[John... Visio MVP]

Sounds like an argument from a two year old.

John... Visio MVP