Defaul Value

[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

 

[Alex M.K.]

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

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

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