Hi,
i have the following tables:
tblStandard_Information and tblReview_Information. These have been joined with a key.
I have created a query to display some fields - view this image:
SQL view:
The output is shown in this image:
I only would like to show the line with the highest period end (the yellow ones) for each product name. Is it possible to create a query for this?
---
It's never too late to do the Right thing
i have the following tables:
tblStandard_Information and tblReview_Information. These have been joined with a key.
I have created a query to display some fields - view this image:
SQL view:
Code:
SELECT tblStandard_Information.Product_Name,
tblStandard_Information.APR_Priority,
tblStandard_Information.RPV_Priority,
tblStandard_Information.High_Priority,
tblStandard_Information.In_Frequent,
tblReview_Information.Type,
tblReview_Information.Period_Start_Date,
tblReview_Information.Period_End_Date
FROM tblStandard_Information
INNER JOIN tblReview_Information ON tblStandard_Information.StandardID = tblReview_Information.ReviewID;
The output is shown in this image:
I only would like to show the line with the highest period end (the yellow ones) for each product name. Is it possible to create a query for this?
---
It's never too late to do the Right thing