MEL,
Is there supposed to be a question or suggestion in this posting? If it's a question, you need to provide more significant information about your requirements. If it's a suggestion, I don't see any TOP in the SQL statement.
Duane Hookom
MS Access MVP
To: MS_Access_Professionals@yahoogroups.com
From: girl_moon_godess@yahoo.com
Date: Tue, 12 Jul 2011 21:35:58 -0700
Subject: [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]
Tidak ada komentar:
Posting Komentar