Earliest Date

[Pass-the-reality]

I have a Query that captures Test Start ID and TestStartDate.
I want to pull the earliest date listed for Test Start Date that corresponds
with the Test Start ID number. The name of the Query is PackageStarted2.
Here
is an example of the Query Data.

TestsStart ID TestStartDate
12305 1-1-07
12305 1-2-07

I added the below SQL Statement, but get a Syntax Error in From Clause

SELECT Test Start ID, Min(Test Start Date)
FROM PackageStarted2
GROUP BY Test Start ID

The Entire SQL Statement Reads

SELECT PackageStarted.[Package Numbers], PackageStarted.[Test Start ID],
PackageStarted.[Testing Started], PackageStarted.[Test Case #],
PackageStarted.[Test Start Date]
FROM PackageStarted

SELECT Test Start ID, Min(Test Start Date)
FROM PackageStarted2
GROUP BY Test Start ID

What is causing the error?

 

[Stefan Hoffmann]

SELECT Test Start ID, Min(Test Start Date)
FROM PackageStarted2
GROUP BY Test Start ID

What is causing the error?

Spaces are not allowed in field names. You have to place such names into
square brackets: [Test Start ID] or [Test Start Date].


mfG
--> stefan <--