[AccessD] Error in from clause

Was just replying exactly the same

On 3 January 2013 15:43, Jeff B <jeff.developer at gmail.com> wrote:

> 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
>



-- 
Paul Hartland
paul.hartland at googlemail.com