How to return only one row in Select * query

[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

 

[Ronald]

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

 

[Snurre Sprett]

Works fine, but I sorted in the Merge query..

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





.