Thanks Ck , but I don't know how to do it in Access I'm new to it.
Any help appreciated

I need to create a query in access that will ask me the query name as a parameter from which to get the data field (e.g. Emp_ID. only) . The database is in Microsoft Access and need to automate this task in Access. I don’t know VBA.

Note: If I need d to build the query with string manipulation where would I put the declare, dim statement in the query?
I would appreciate any help, hints or suggestions.
...