ændre poster?

UPDATE YourTable SET valuta = valuta * 6.8

6.8 is your calculation factor which obviously you need to change

Og hvordan/hvor indsætter jeg dette? Jeg er totalt nybegynder...

Kim

The example I gave actually updates (changes) the original value. It may be best if you make a query and then just calculate the dansk.
This way you can see the original and the dansk.
Another question. Is there only one udenlandsk valuta say DM (German) or are there many ? IN other words is ther more than one calculations factor?

Der er kun 1 udenlandsk valuta. Men jeg ved overhovedet ikke hvordan/hvor jeg kommer ind og skriver den formel du gav mig???

Kim

Send you dB to
dkTeBrSa@Europe.lego.com (.com) is part of the hyperlink.

I need to know if you want to update (change) your udenlandsk valuta or do you want to be able to see both. I also need the calculation factor.

My dB is 48MB big so I won\'t send it. I want to update (change) the my udenlandsk valuta.

Kim

OK. You need to make a query.
Select Queries then New then Design View (English version of Access). The press OK and then Cancel when you see the list of tables in your database.

Then right click on the empty area of the query and select SQL View. You will see something like SELECT; Cut and paste this

UPDATE YourTable SET valuta = valuta * 6.8;

to replace the SELECT;

Then you need to alter YourTable  to the name of your table.
And change valuta  to the name of the field in the table. Then change 6.8 to the calculation factor you want to use.
Then press the RED ! (run) symbol in the menu bar. This will execute your code if it is correct.

Jeg går ud fra at du fortsat ønsker at kunne se kronebeløbet i feltet, og at valutabeløbet skal stå i et andet felt.

Lav en opdateringsforespørgsel, hvor du vælger det felt valutabeløbet skal stå i. I \"opdater til\" angiver [kronefeltets navn]* valutakursen.

Hedder kronefeltet f.eks. beløb og kursen der skal omregnes med er 3,87 skal du skrive [beløb]*3,87

mvh
Torben