Solved

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

Posted on 2011-02-13
3
433 Views
Last Modified: 2012-05-11
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.
0
Comment
Question by:vsllc
3 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 500 total points
ID: 34885431
Sure ... like this:

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


mx
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 34885432
select f1,f2, [Enter Data] as f3
from tablex
0
 

Author Comment

by:vsllc
ID: 34885464
Worked perfectly!
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question