We all have those days. That's why we have each other. :-)
Liz Ravenwood
Database Developer / Programmer
Super First Class Products
B/E Aerospace
O: 1.520.239.4808
www.beaerospace.com
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Pamela Zimmerman
Sent: Tuesday, February 28, 2012 1:07 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Re: sql problem
This is one of those times where I feel like a doof because I just didn't
see that J Thanks Duane.that works wonderfully. J
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Duane
Sent: Tuesday, February 28, 2012 1:38 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: sql problem
I would remove part of the join that is constant and put it in a where
clause.
--- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> , "Pamela Zimmerman"
<pzimmer@...> wrote:
>
> Hello folks,
>
>
>
> I have a function that accepts a date/time value and a string value and
uses
> the values in a sql string (excerpt below). An error is thrown at the
> 'ssql = ' line that says '3296 Join Expression Not Supported'. The join is
> a compound key field which is composed of a date/time stamp field
> (sTimeStamp) and a text field (plannerID). The join works ok in the query
> grid, but I can't seem to get it right in the code.
>
>
>
> I've been working on this for too long and would appreciate suggestions.
> Thanks!
>
>
>
> Public Function SiteRemStr(sTimeStamp As Date, pID As String) As String
>
>
>
> Dim ssql As String
>
>
>
> ssql = "SELECT SiteDetail.siteTimeStamp, SiteDetail.plannerID,
> SiteRem.siteRemDesc " _
>
> & "FROM (qryWorkOrderStart " _
>
> & "INNER JOIN SiteDetail " _
>
> & "ON (qryWorkOrderStart.siteTimeStamp = #" & sTimeStamp & "#) " _
>
> & "AND (qryWorkOrderStart.plannerID = '" & pID & "')) " _
>
> & "INNER JOIN SiteRem " _
>
> & "ON SiteDetail.siteRemID = SiteRem.siteRemID;"
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
[Non-text portions of this message have been removed]
------------------------------------
Yahoo! Groups Links
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Tidak ada komentar:
Posting Komentar