Afledet værdi

In the before update event on your form you can write

Me.Pris_ialt = Me.antal*me.stk_pris

Vil tro at man i standart værdien kan skrive stk_pris * antal

But whats that when record isnt yet created?

Nej netsrac det kan man åbenbart ikke :o(

Terry: where du I set the \"Befor Update\" event?

I am assuming that you enter your data on a form. So in the forms properties (desgign view) you can choose the BeforeUdate event and then just add the code I mentioned. What happens here is that just before the record gets written it takes the values of the other two forms and calculates the third field.

Actually im updating the database via ODBC/ASP, but maybe that will not make any difference...

So you have the values in your hands before you write to the dB via ASP. Just calculate it yourself, whats hard about that?

Absolutley nothing... i just think it would make the code perform better if access could handle the calculations internaly

I doubt it would help at all.

Well.. I vill not have to worry about formatting the data for input in a currency-field for one thing.. it seems to me that ther\'s a lot less things that coud go wrong this way.... But i guess it\'s a long discussion.. Your remark that it will not help is now noted :o)

You dont have to format the data as a currency field if you already have two valid fields (antal + stk_pris). If your using an SQL INSERT statemnet then you could have variable which gets the value from the other two fields.

Dim myVar
myVar = Request.Form(\"Antal\") * Request.form(\"stk_pris\")


Then include myVar in your INSERT statement
No nothing about ASP but I assume it ssomething like that

Yes you\'r right, but what I want is letting the Database \"do the work\".... It\'s not tha i cant accomplish the calculation/insertion ;o)

I can see the logic in what you are attempting to do but I must admit, I dont think it is possible. I dont think the values of these fields are available when the default value is set into the pris_ialt field. Another thing, why have a pris_ialt field, it can always be calculated?

Your right... im sacreficeing data space in order to eleminate the need for calculations.. wich is not as great an idea as i thougt to begin with.

Im going to drop the pris_ialt field...

Tanks for helping me out :o)