Search results

Solved! Thanks!

Mostly report but if possible in form then id like to know that aswell! :)

Hiho..! Easy question here but I can't figuere it out in 02! How do I add a sum row of the column in access 02 at the end of the column? Many thanks!

That worked, did it in two seperate updates instead, one for all but sek and one for only sek. Thank you Mihail!

IIf([CURRENCY]="SEK";[Value_Diff];[RATE]*[Value_Diff]) Still doesnt work.. I'll keep testing stuff tho and see if it works out! Thanks alot for the help so far tho, I've come alot longer since when I started so :)!

Thanks alot Brian :)! However when I put it like this it still doesnt copy the value for the currency thats alrdy sek! IIf ([CURRENCY]=SEK; [Value_Diff_SEK]; [RATE]*[Value_Diff])

Many thanks that was the issue, however I've come up with another problem now.. Anything you knw? I want to update a column [Value_Diff_SEK] to a value gained from [Value_Diff]*[rate]. (it takes the value and multiplies it with the swedish SEK rate). However, for those values that already...

Hi! I want to make a copy table where I copy all the values from a database and filter out the values that I want. In one of the columns theres a number value that can't be changed manually to text, for that value I want to convert it and ignore the null values. So I only want to show the...

Hiho! Looking for a solution for this problem for microsoft Access! When I am importing a date value it mixes up the year/month/day value and enters the year as date and the day as the year. Anyone know the conversation for this? I've tried with CorrDate: Format([REPORT_DATE];"yyyy/mm/dd") but...

I am swedish :)