Selecting first record

  • Thread starter Thread starter Guest
  • Start date Start date
In a sorted table, is there a way to select the first
record for a group?

Since Tables cannot be sorted nor do they have groups, as stated, the
answer is No.

However, you can create a Totals query. What constitutes "the first
record"? There must be a field in the table to identify both the group
and the sequence within the group; could you explain what these are?
 
Back
Top