How do I select only the top record of each day when the table ha.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using Access 2003. Have table of employee time sheets. Need to select start
time of each employee on each day.
 
Using Access 2003. Have table of employee time sheets. Need to select start
time of each employee on each day.
Click to expand...

Without knowing anything about the structure of your table, or what
you mean by "top record" from your subject line or "time of each
employee" in the question, it's impossible to say. Could you explain?

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
You must log in or register to reply here.

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

How to count consecutive records base on 2 groupings 0
Need to select record based on date 5
Duplicate a set of rows for each item (subdatasheet?) 0
top 2 records for groups in query? 2
Select records by employee 3
Ranking in Access Query by Dates 1
Left Join Question 2
Not display information if criteria is not met 2

Back
Top