Query fails, incorrect use of join ?

kirkm · Mar 21, 2015

I supect my design is flawed

Code:

    SELECT tblData2.Prefix, tblData2.LineNum, tblData2.Year, tblComments.comment, tblComments.Address
    FROM tblData2 LEFT JOIN tblComments ON tblData2.LineNum = (NumbersOnly([tblComments].[Address])
    WHERE (((tblData2.MyYear)<1990))
    ORDER BY tblData2.LineNum;

The NumbersOnly function returns a set of numbers from a custom formatted string.
The above fails on the join (I think) but maybe there's another way of doing it?
Thanks for any advice.

plog · Mar 21, 2015

Maybe, but I do know you have a syntax error: You're missing a closing parenthesis in the JOIN,.

jdraw · Mar 21, 2015

Welcome to the forum.

This post seems eerily similar to
http://www.accessforums.net/queries/using-join-result-function-will-not-compile-51195.html

It isn't wrong to cross post, but proper etiquette would be for you to inform readers that you have done so.

I realize this is your first post here, and thought I should mention this for reference.

Here's why.

kirkm · Mar 21, 2015

jdraw, my apologies... never knew there was a connection. I'd waited a couple of days and no answer (which I still need) so thought I'd try somewhere else. Plus the issue had sidetracked to a non relevant discussion and I altered my post here to avoid that. I've read the here's why and understand for the future. plog - may thanks. That was the issue

jdraw · Mar 21, 2015

Glad you have it solved.

Query fails, incorrect use of join ?

kirkm

Registered User.

plog

Banishment Pending

jdraw

Super Moderator

kirkm

Registered User.

jdraw

Super Moderator

Similar threads

Users who are viewing this thread