[MS_AccessPros] Select top 5 values from query

 

This is the main query and i have to show only top 5 values from Cost Per Person field

SELECT Reservation.ReservationID, Reservation.StartDate, Reservation.EndDate, Property.PropertyID, Property.PropertyName, Reservation.People, Reservation.Rate, Format([Rate]/[People],"Currency") AS [Cost Per Person]
FROM Property INNER JOIN (Guest INNER JOIN Reservation ON Guest.GuestID = Reservation.GuestID) ON Property.PropertyID = Reservation.PropertyID
ORDER BY Format([Rate]/[People],"Currency") DESC;

[Non-text portions of this message have been removed]

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (7)

Recent Activity:

• New Members 8
• New Files 6

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___