Selecting First Entries

#1

I have a query that displays around 600 entries for about 65 students
that are grouped by name and then by time and day of their classes for
that week.
I need to see only the first entry for each student with the time and
day of their first class for the week.
How do I select these entries for a report and not display the rest?

#2

On Nov 27, 7:06*pm, Deac <mwal... (AT) centurylink (DOT) net> wrote:

Quote:

I have a query that displays around 600 entries for about 65 students
that are grouped by name and then by time and day of their classes for
that week.
I need to see only the first entry for each student with the time and
day of their first class for the week.
How do I select these entries for a report and not display the rest?

I assume you created a "totals" query In the querybuilder. Open up
the query. In the Time/Date field click on the dropdown and change
the "GroupBy" to "First".

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Selecting First Entries

comp.databases.ms-access comp.databases.ms-access

Selecting First Entries - 11-27-2011 , 07:06 PM

Re: Selecting First Entries - 11-28-2011 , 09:14 AM