Query with table name as variable

[Avizan05]

Hi,

In my application, table for a query is choosen based on the user input.I have declared the user input as Tempvars.I want to know how to use the variable in query design(not using VBA).

 

[pr2-eugin]

A simple Google came up with several hits, this seemed to be quiet easy to follow. http://www.utteraccess.com/wiki/index.php/TempVars

 

[Avizan05]

Thanks eugin for your response.

As i have mentioned, i am using tempvars not in code(VBA) but in query design mode of access and i have given try with all the suggested method from your link.none seems to be working..
I am getting an error message : "syntax error in from clause" since the syntax has parentheses or exclamation mark which are not accepted.

 

[pr2-eugin]

Not sure how are you using, it should be like TempVars!yourVariableName

 

[Galaxiom]

In my application, table for a query is choosen based on the user input.I have declared the user input as Tempvars.I want to know how to use the variable in query design(not using VBA).

This cannot be done without building a dynamic query VBA.

Moreover, such a requirement usually indicates the data structure is wrong. It would appear you are storing information by putting records into different tables. Information should not be held in this way.