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?
Click to expand...

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Random Function for Selecting Records 3
calculation based on previous record 0
complex query to pull unique values 6
Agregate query (first) not returning "first" record from a sub que 1
Access Dcount (multiple criteria) 3
not in criteria fails 2
Difficult Select Query 4
Turning look up values into fields in a query 2

Back
Top