Hi
I recently had some assistance that gave me the following query
SELECT Top 1 T1.ItemCode, T1.Dscription, T0.DocDate,T1.Quantity,
T0.DocNum, T0.CardCode, T0.CardName
FROM dbo.OPOR T0
INNER JOIN dbo.POR1 T1 ON T0.DocEntry = T1.DocEntry
WHERE (T1.ItemCode ='[%0]' OR T1.Dscription = '[%1]'
Order By T0.DocDate DESC
However I would like to amend this so I could enter 4 or 5 different ItemCode or Dscription in the Selection Criteria, and it return the latest documents for each one.
Many thanks.
A