LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Frans van Zelm
 
Posts: n/a
Default MS Query, command View-Query Properties

Hi there,

In View-Query Porperties you have options for:
- Unique Values
- Group Record

The first option reduces the result set to one row for field values a-b-c.
That's clear.

But what about Group Records? To me, it looks similar.

And how do these two options cooperate / interfere with the [Totals] button
which sets Sum, Avg etc. to the selected column.

Thanks for a reply.

Frans


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Query of External Data Excel GuRu Excel Discussion (Misc queries) 2 January 3rd 05 07:43 PM
saving wkbk minus MS Query links Bill_S Excel Discussion (Misc queries) 1 January 3rd 05 06:00 PM
Pivot Tables referring to external data query Excel GuRu Excel Discussion (Misc queries) 4 December 29th 04 06:29 PM
New web query with Excel Pro Edition 2003 Chandler Links and Linking in Excel 2 December 15th 04 06:03 PM
How to use a Access Query that as a parameter into Excel database query Karen Middleton Excel Discussion (Misc queries) 1 December 13th 04 07:54 PM


All times are GMT +1. The time now is 02:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"