Calculated field

On Mon, 27 Oct 2008 10:15:01 -0700, Cesar
wrote:

I'm new using Access, so this may be pretty easy but I can figure outhow to
do it.

I need to calculate a new field (sales commisions) just multiplying the
sales value times the percent of commission, the problem is that the percent
of commision is not a value in a table as the sales value is; this percent of
commission is a changable value and actually I would like to be ask what is
that percent every time I run the query

Thanks

In your Query you can put an expression in [square brackets] to generate a
prompt; i.e. you can have an expression

Comm: [SalesValue] * [Enter commission rate as fraction, e.g. .08 for 8%:]

If you want to enter 8 instead of .08, prompt accordingly and divide the
result by 100.
--

John W. Vinson [MVP]

Try changing it to Sales Times Commission

--
KARL DEWEY
Build a little - Test a little


"Cesar" wrote:

Karl,

The column name is actually the equation, Sales * [% of commission]
--
Cesar


"KARL DEWEY" wrote:

I got a message that says Invalid column name,
I am not familiar with Excel queries. Just what did you use for column name?
--
KARL DEWEY
Build a little - Test a little