Defaul Value

  • Thread starter Thread starter Alex M.K.
  • Start date Start date
A

Alex M.K.

Dear All,

I have a table with payments, I have fields that Price, Quantity
I want that in the same table to have a Total that is the result of (Price *
Quantity)
Is it possible? If yes HOW?

Thanks Alex
 
I may not understand what is going on here, but normally you would not
store the result of a computation based on numbers already in a table, you
just compute it each time you need it.

If you want to see the totals, just use a query. Add a field called
Total: [Price]*[Quantity] .
 
The problem is that in the Query I cant round decimals to 2 digits. I mean
really rounded, if you know how to round decimals in a Query, so I have as a
value a number with 2 decimals (not more) it will be grate.

Alex


Joseph Meehan said:
I may not understand what is going on here, but normally you would not
store the result of a computation based on numbers already in a table, you
just compute it each time you need it.

If you want to see the totals, just use a query. Add a field called
Total: [Price]*[Quantity] .

--
Joseph E. Meehan

26 + 6 = 1 It's Irish Math


Alex M.K. said:
Dear All,

I have a table with payments, I have fields that Price, Quantity
I want that in the same table to have a Total that is the result of
Click to expand...
(Price
*
Quantity)
Is it possible? If yes HOW?

Thanks Alex
Click to expand...
Click to expand...
 
Why is this important? That is what does it have to be compared to?
There are several ways of rounding so the results you get, using any program
or doing it manually, are not going to always be the same from one system to
the other. As I recall Access uses a Banker Rounding.

--
Joseph E. Meehan

26 + 6 = 1 It's Irish Math


Alex M.K. said:
The problem is that in the Query I cant round decimals to 2 digits. I mean
really rounded, if you know how to round decimals in a Query, so I have as a
value a number with 2 decimals (not more) it will be grate.

Alex


Joseph Meehan said:
I may not understand what is going on here, but normally you would not
store the result of a computation based on numbers already in a table, you
just compute it each time you need it.

If you want to see the totals, just use a query. Add a field called
Total: [Price]*[Quantity] .

--
Joseph E. Meehan

26 + 6 = 1 It's Irish Math


Alex M.K. said:
Dear All,

I have a table with payments, I have fields that Price, Quantity
I want that in the same table to have a Total that is the result of
Click to expand...
(Price
*
Quantity)
Is it possible? If yes HOW?

Thanks Alex
Click to expand...
Click to expand...
Click to expand...
 
Back
Top