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.
vsllcAsked:
Who is Participating?
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
Sure ... like this:

SELECT Table1.*, [Enter Your Data] AS MyPrompt
FROM Table1;


mx
0
 
Rey Obrero (Capricorn1)Commented:
select f1,f2, [Enter Data] as f3
from tablex
0
 
vsllcAuthor Commented:
Worked perfectly!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.