caculate a dollar amount of entries in a column in Access

B

blackmax200

I want Access to have a column in a table that displays the result of
multiplying the number in a specific column by a fixed dollar amount. This
information is then used to import into a Word document form. The books are
not too clear on doing this. Thanks any help will be appreciated.
 
M

Martin Fishlock

There are two appraches that I would consider:

Linked table or fixed query

With a linked table there is a direct link between the row and the amount
and you write a query to multiply a X b

otherwise you write a query with a X 3.142 or whatever number it is (it
could be specified as a parameter to the quwery).
 
K

Klatuu

Storing any calculated value in a table violates the most basic rules of
database design. Do your export to Word using a query. Add a column to the
query that will perform the calcluation.
 
B

blackmax200

Martin thank you for the ideas. The linked table is what I think I would
like to do as this would be more easily written and displayed in the form
that is used. I think what I am looking for is the specific syntax that
would be written into the cell to get the result displayed.
 
B

blackmax200

Yes you are correct, slap me up the side of the head. I am not sure of the
specific syntax. Could you please help me there?
 
K

Klatuu

In your query builder, where you would put the field name:
Total: [FieldName1] * 5

This would be $5.00 * the value in FieldName1
 
B

blackmax200

Thank You, Works great. I guess I can get the display to show "Currency"
format somehow.
Thanks again
matthew

Klatuu said:
In your query builder, where you would put the field name:
Total: [FieldName1] * 5

This would be $5.00 * the value in FieldName1

blackmax200 said:
Yes you are correct, slap me up the side of the head. I am not sure of the
specific syntax. Could you please help me there?
Click to expand...
Click to expand...
 
K

Klatuu

Sure can. In design mode of the query builder, right click on your calculated
field, select properties, then select currency.

blackmax200 said:
Thank You, Works great. I guess I can get the display to show "Currency"
format somehow.
Thanks again
matthew

Klatuu said:
In your query builder, where you would put the field name:
Total: [FieldName1] * 5

This would be $5.00 * the value in FieldName1

blackmax200 said:
Yes you are correct, slap me up the side of the head. I am not sure of the
specific syntax. Could you please help me there?

:

Storing any calculated value in a table violates the most basic rules of
database design. Do your export to Word using a query. Add a column to the
query that will perform the calcluation.

:

I want Access to have a column in a table that displays the result of
multiplying the number in a specific column by a fixed dollar amount. This
information is then used to import into a Word document form. The books are
not too clear on doing this. Thanks any help will be appreciated.
Click to expand...
Click to expand...
Click to expand...
 
Top