min and max dates

[Guest]

having trouble with using min and max functions to return dates. need to select the min and max date for each item# from a table. multiple date entries for each item#. i already created a query to rank dates so do have ranking on each date for each item. maybe i should use rank in next query instead!?! thx.

 

[fredg]

having trouble with using min and max functions to return dates.

need to select the min and max date for each item# from a table.
multiple date entries for each item#. i already created a query to
rank dates so do have ranking on each date for each item. maybe i
should use rank in next query instead!?! thx.

Does this help?

SELECT DISTINCT YourTable.ItemNum, Max(YourTable.ADate) AS MaxDate,
Min(YourTable.ADate) AS MinDate
FROM YourTable
GROUP BY YourTable.ItemNum;