
Parameter query w/ parameter specifying field name?
Is is possible to create a parameter query where the parameter specifies the name of
a field (rather than a value to check for in a specified field)? For example:
PARAMETERS [Enter field name:] Text;
SELECT DISTINCTROW Veg.Name
FROM Veg
WHERE (([Enter field name:] = Yes));
When I try this I get an error that the expression cannot be evaluated. Is there an
alternate syntax that would allow this type of query?
Dave Hamilton