A
Alex
I have the following records in a table called Info:
One Two Three Four Change Date
1 2 3 2 1/1/2005
1 2 3 3 3/1/2005
6 7 8 9 1 3/1/2005
6 7 8 9 2 3/1/2005
I have a query called InfoQuery:
SELECT Infne, Info.Two, Info.Three, Info.Four, Max(Info.Change) AS
MaxOfChange, Info.Date
FROM Info
GROUP BY Infne, Info.Two, Info.Three, Info.Four, Info.Date;
The query result is:
One Two Three Four MaxOfChange Date
1 2 3 2 1/1/2005
1 2 3 3 3/1/2005
6 7 8 9 2 3/1/2005
I want the results to be:
One Two Three Four MaxOfChange Date
1 2 3 3 3/1/05
6 7 8 9 2 3/1/05
How can I include the Date field in the query without grouping by Date?
Thanks
One Two Three Four Change Date
1 2 3 2 1/1/2005
1 2 3 3 3/1/2005
6 7 8 9 1 3/1/2005
6 7 8 9 2 3/1/2005
I have a query called InfoQuery:
SELECT Infne, Info.Two, Info.Three, Info.Four, Max(Info.Change) AS
MaxOfChange, Info.Date
FROM Info
GROUP BY Infne, Info.Two, Info.Three, Info.Four, Info.Date;
The query result is:
One Two Three Four MaxOfChange Date
1 2 3 2 1/1/2005
1 2 3 3 3/1/2005
6 7 8 9 2 3/1/2005
I want the results to be:
One Two Three Four MaxOfChange Date
1 2 3 3 3/1/05
6 7 8 9 2 3/1/05
How can I include the Date field in the query without grouping by Date?
Thanks