[AccessD] Error in from clause

If I am counting my ) correctly the third ) ties back to the one in front of SELECT at the start of the subquery. Thanks.

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

Check your Group statement, extra ) :

> GROUP BY PID, CDate(INT(StatusDate)))<<<<<  AS t2 ON (t1.PID = t2.PID) 
> AND

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:59 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Error in from clause

Upon further examination the error in from clause now highlights GROUP. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Paul Hartland
Sent: Thursday, January 03, 2013 9:50 AM
To: Access Developers discussion and problem solving
Subject: Re: [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
--
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


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