Calculated Fields with User Input

A

Amanda

Hi Everyone,

I would like on of the fields in my Query to be a calculation where the user
inputs some of the information.
Total Paid: [percentage]*[price]
Where: [percentage] is another field in the query
[price] is a value which the user is prompted to
fill in when they run the query.

Is this possible? If so how?

Thanks.
 
D

Dodo

=?Utf-8?B?QW1hbmRh?= wrote on 30 aug 2007:
I would like on of the fields in my Query to be a calculation where
the user inputs some of the information.
Total Paid: [percentage]*[price]
Where: [percentage] is another field in the query
[price] is a value which the user is prompted
to
fill in when they run the query.
Click to expand...

Add a field to the query like:

Price: [?]

When opening the query you will be asked to give the price.
 
O

Ofer Cohen

You can put it just as you wrote it, as long that the price field does not
exist in the table the user will be prompt to enter the value

A new field in the query

Total Paid: [percentage]*[price]

Or, in SQL

SELECT [percentage]*[price] As [Total Paid]
FROM TableName
 
Top