caculate a dollar amount of entries in a column in Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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).
 
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.
 
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.
 
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?
 
In your query builder, where you would put the field name:
Total: [FieldName1] * 5

This would be $5.00 * the value in FieldName1
 
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...
 
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...
 
Back
Top