By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,477 Members | 1,602 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,477 IT Pros & Developers. It's quick & easy.

"Select single * " in ACCESS 2000

P: n/a
I am using Access2000 . In a query window, after selection of a group
of records using aggregate function "group by", I want to
retrieve only one record from each group including ungrouped fields
also.
For example, from the following records,

A B C
A B D
A B E
A H F
A H G,
i am grouping on first and second fields . I want results
like this:
A B C
A H G .
The selection of C, D or E could be first matching value or random ,
but it must be included in the results.

Is this possible in Access ? Is there any workaround ?

Thanks in advance .

=======

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Create field "fldNewField: left([oldfield],2)" and group on that

Then change the parameter for the old field from "Group by" to "Last"
or "First".

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.