Keyword - Last

  • Thread starter Thread starter Gary Nelson
  • Start date Start date
G

Gary Nelson

I created a view in MS Access2000 (frontend) SQL Server (backend). I have a
report which is based on the view. The report is giving me all entries that
were made based upon a specific order number. I only want the Last entry to
appear on the report. Can someone offer assitance as to the ppocedure for
doing this in a view?

Thanks
 
if you are using an Auto number you can use Top 1in the SQL this will give
you the greatest number of of the records.
hope this helps
 
Back
Top