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

 

[Kevin3NF]

answered in .tabledesign

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

 

[Joseph Meehan]

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] .

 

[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

 

[Joseph Meehan]

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

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