Field Name as a value (1 Viewer)

P

plumby

Guest
I have a query where I wish to use the name of a field as a value. Can anyone help with how I would achieve this.
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 03:47
Joined
Feb 19, 2002
Messages
43,223
If by your question you mean that you want to change the select list or selection criteria of a query on the fly, you'll need to do it with VBA. You cannot pass parts of an SQL statement to a query as parameters. Parameters are only used to supply data values. They cannot be used in any manner that actually modifies the syntax of the statement.
 

Users who are viewing this thread

Top Bottom