Calculated Fields with User Input

[Guest]

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.

 

[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.

Add a field to the query like:

Price: [?]

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

 

[Guest]

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