Keyword - Last

[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

 

[Dib]

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