Link to home
Start Free TrialLog in
Avatar of vsllc
vsllc

asked on

Create a new field in a query that is populated with user input.

I can create a new field in a query and hard code a value or blank value.  Is it possible to create a new field in a query that is populated with data keyed into a prompt from a user?  The data keyed into the prompt can be anything and will not be used to filter query results at all.  It is simply a variable field that will show in the query results.
ASKER CERTIFIED SOLUTION
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
select f1,f2, [Enter Data] as f3
from tablex
Avatar of vsllc
vsllc

ASKER

Worked perfectly!