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.

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.