LutonBarry
11-17-2015, 05:10 PM
I adapted the formula in italics below to match my Table name and columns. When I run my formula an Enter Parameter Value box for "Activitiesxx02.Ticket_Id" appears, whereas no parameter value box does for the one in italics. Anyone have an idea why and what I need to do?
SELECT Table1.col1, Max(Table1.col2) AS MaxOfcol2
FROM Table1
GROUP BY Table1.col1;
SELECT Activitiesxx02.Ticket_Id, Min(Activitiesxx02.Start_DateTime) AS MinStart
FROM Activitiesxx02
GROUP BY Activitiesxx02.Ticket_Id;
SELECT Table1.col1, Max(Table1.col2) AS MaxOfcol2
FROM Table1
GROUP BY Table1.col1;
SELECT Activitiesxx02.Ticket_Id, Min(Activitiesxx02.Start_DateTime) AS MinStart
FROM Activitiesxx02
GROUP BY Activitiesxx02.Ticket_Id;