Retreive most recent query

D

Dj

My Access table has one record per employee for each month. This month I
have 3 months uploaded and the Month_Field fields for each employee are
6/30/08, 7/31/08 and 8/31/08.
My info path form query, when I enter the employee number, retreives all
three records. I only want to retreive the last record entered, or the most
recent record based on the Month_Field.
What's the easiest way to do this? I tried the max function, but that
didn't work. Hopefully, it won't require coding. Thx! Dj
 
H

Harikrishna

Hi Dj,

This query might workout for you:
select top 1 [ID],[Month_Field],[Field2] from [Practice] as [Practice]
order by [Month_Field] desc
 

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

Retrieving the most recent record from each person 5
accepting most recent date across columns 10
Query to display the difference of period for an employee. 1
Exclude most recent month 3
Search Columns for Most Recent Date 1
Most Recent Record in a set 1
show the most recent payment 8
Need help with a query 1

Top