calculation

[Matt M.]

My access book says that I should never include calculated fields in
my tables, so I deleted them.

Now I want to multiply a field by 2% and display the results. How can
I do this?

 

[Amy Blankenship]

Use a query, form, or report.

 

[fredg]

My access book says that I should never include calculated fields in
my tables, so I deleted them.

Now I want to multiply a field by 2% and display the results. How can
I do this?

In a query.
NewColumn:[FieldA] * .02

Directly in an unbound control on your form or report:
=[FieldA] * .02

 

[Matt M.]

Use a query, form, or report.







- Show quoted text -

In my query I placed the field that I want to multiply by 2%. Then I
used !build to do a calculation. My calculation is [My Database]!
[Totals]*2/100.

When I run the query I get this error: " You tried to execute a query
that does not include the specified expression "Totals" as part of an
aggregate function.

 

[Matt M.]

My access book says that I should never include calculated fields in
my tables, so I deleted them.

Now I want to multiply a field by 2% and display the results.  How can
I do this?

In a query.
NewColumn:[FieldA] * .02

Directly in an unbound control on your form or report:
=[FieldA] * .02

In the query design view, which row do I put my calculation in?
options are: Field, Table, Sort, Show, Criteria, and Or.

 

[dan.rei1]

Field.

My access book says that I should never include calculated fields in
my tables, so I deleted them.

Now I want to multiply a field by 2% and display the results. �How can
I do this?

In a query.
NewColumn:[FieldA] * .02

Directly in an unbound control on your form or report:
=[FieldA] * .02

In the query design view, which row do I put my calculation in?
options are: Field, Table, Sort, Show, Criteria, and Or.

 

[Matt M.]

Field.

On Wed, 6 Feb 2008 09:05:41 -0800 (PST), Matt M. wrote:
My access book says that I should never include calculated fields in
my tables, so I deleted them.
Now I want to multiply a field by 2% and display the results. �How can
I do this?
In a query.
NewColumn:[FieldA] * .02
Directly in an unbound control on your form or report:
=[FieldA] * .02

In the query design view, which row do I put my calculation in?
options are: Field, Table, Sort, Show, Criteria, and Or.- Hide quoted text -

- Show quoted text -

That worked. Thanks!

 

[Larry Linson]

My access book says that I should never include
calculated fields in my tables, so I deleted them.

As Access has no provision for creating calculated Fields in Tables, I am a
little puzzled by your statement. How do you delete something that couldn't
be created in the first place?

Larry Linson
Microsoft Office Access MVP

 

[Fred]

Usually when people say that it means that they have a regular field and then
load it via a calculation. f