parameterized INNER JOIN Query

[englishkid19]

Hi All ,
I'm trying to get users to specify the ON clause of an INNER JOIN ? I cant get the syntax right. Essentially all i want the query to do is run exactly as it does but allow the user to input the Resource Base in the ON Clause....

SELECT AGMInput.*, AnalystInput.TOB, AnalystInput.Crews,
FROM AnalystInput INNER JOIN AGMInput ON AnalystInput.ResourceBase = AGMInput.ResourceBase
WHERE AGMInput.DateAdded = AnalystInput.Date;

Please help ....
Thanks

 

[Joe4]

I would recommend creating a Form where they can input that, and then take the input and build the SQL in VBA.
Have a look here: Building SQL in VBA

 

[englishkid19]

I would recommend creating a Form where they can input that, and then take the input and build the SQL in VBA.
Have a look here: Building SQL in VBA

yes i think thats the next step once i get this working .... just to prove its functionality

 

[james_lankford]

you also have a comma at the end of your first line

 

[Joe4]

Sorry, I didn't realize that in addition to wanting to make the JOIN field dynamic, you were having a problem with your original code.
One little easy trick you can do in these situations, is use Access Query Builder to build the query you want. When you have it working the way you like, switch to SQL View and compare the SQL code there with what you have written and look for any differences.

 

[englishkid19]

Sorry, I didn't realize that in addition to wanting to make the JOIN field dynamic, you were having a problem with your original code.
One little easy trick you can do in these situations, is use Access Query Builder to build the query you want. When you have it working the way you like, switch to SQL View and compare the SQL code there with what you have written and look for any differences.

Hi all,
I have it sorted now .
Thanks