[AccessD] Error in from clause

Unfortunately I am still getting the error with the ( )

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jeff B
Sent: Thursday, January 03, 2013 9:43 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Error in from clause

Right off the bat, I'd say look at your WHERE statement, you are missing an opening ( and a closing )

WHERE   HERE > t1.StatusDate)>CDate([Allocation_Stats]![DateLast_S]  <HERE

Jeff Barrows
MCP, MCAD, MCSD
 
Outbak Technologies, LLC
Racine, WI
jeff.developer at gmail.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester
Sent: Thursday, January 03, 2013 9:41 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Error in from clause

The following query is giving me an error in from clause message. It highlights the > in the where statement. The subquery works ok on its own.
What am I missing? Thanks.

SELECT t1.PID, Left([t1.PID],10) AS API10, t1.Completion_Name,
WellStatus([Status]) AS StatusShort, CDate(Int([StatusDate])) AS Status_Date FROM dbo_DSS_StatusChanges  AS t1 INNER JOIN (SELECT DISTINCT PID, CDate(INT(StatusDate)),
min(StatusDate) AS lastdatetime
FROM dbo_DSS_StatusChanges
WHERE t1.StatusDate)>CDate([Allocation_Stats]![DateLast_S]
GROUP BY PID, CDate(INT(StatusDate)))  AS t2 ON (t1.PID = t2.PID) AND (t1.StatusDate = t2.lastdatetime);
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com