S
stevecarter31
Guest
I have a parameter query in Access 2000 as follows:
SELECT test.country, test.name
FROM test
ORDER BY [@Parameter]
I am prompted to input the @Parameter. However, the result is not sorted by the parameter I input (i.e. I input 'Name' or 'Country' without the quote).
Can anyone pls help me on this simple but urgent problem? Thanks a lot!!
SELECT test.country, test.name
FROM test
ORDER BY [@Parameter]
I am prompted to input the @Parameter. However, the result is not sorted by the parameter I input (i.e. I input 'Name' or 'Country' without the quote).
Can anyone pls help me on this simple but urgent problem? Thanks a lot!!