How to return only one row in Select * query

  • Thread starter Thread starter Snurre Sprett
  • Start date Start date
S

Snurre Sprett

Hi.

My query is:

"select * from Merge where Employee.EmployeeID = " &
lngSubId

Merge is a query merging two tables and lngSubId is the
EmployeeID on a subform.

There is a date field in here and I want to return only
the row with the highest date, as I am going to merge this
to Word..

How do I code this in VBA or the Merge query.?

Appreciate all hints and tricks..

Regards
Snurre
 
select top 1 * from Merge where Employee.EmployeeID = " & lngSubId & "
ORDER BY MyDate DESC"
 
Works fine, but I sorted in the Merge query..

-----Original Message-----
select top 1 * from Merge where Employee.EmployeeID = " & lngSubId & "
ORDER BY MyDate DESC"





.
Click to expand...
 
Back
Top