Parameter query w/ parameter specifying field name? 
Author Message
 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



Sun, 05 Apr 1998 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. parameter query in VBA when parameter not a field

2. Passing name of field as query parameter

3. field name used in parameter query?

4. parameter query, inputing field name

5. calling parameter query from a parameter query

6. Parameters specified in module query

7. Specify parameter in code for UpdateTable query?

8. Specify parameter in code for UpdateTable query?

9. This field name is not known(parameter field) in crystal8

10. Filling a Parameter through Code (Parameter Query)

11. Using Parameters from VBA Code in a Parameter Query Export

12. Using Parameter Queries with Optional Parameters

 

 
Powered by phpBB® Forum Software