MAFRUND eller MROUND i Access

havent tried this but heres a link I just found, sure there will be others

https://www.pcreview.co.uk/threads/access-function-like-excel-mround-function.3778485/

Your questions seems top contain two problems, one a replacement for MROUND and another, how to use values from two records?

Hej Terry
Jeg har faktisk kigget på den tråd før - min udfordring er at jeg skal kunne lave en formel der afrunder til næste hele multiplum og ikke kvartal - men multiplum er forskellig fra varenr til varenr.

Min excelfunktion ser således ud:
=MAFRUND(TAL;MULTIPLUM)

Hvordan kan jeg oversætte det til Access sprog? Enten via SQL eller en formel...

Jeg har fundet dette script, men jeg kan ikke finde ud af om det gør det rigtige:

Function wMRound(pValue As Double, multiple) As Double
    Dim negNumber As Boolean
    If pValue < 0 Then
        pValue = 0 - pValue
        negNumber = True
    End If
    If multiple < 0 Then
        multiple = 0 - multiple
    End If
   
    Select Case pValue / multiple - Int(pValue / multiple)
        Case Is < 0.5
            result = Int(pValue / multiple) * multiple
        Case Is >= 0.5
            result = Int(pValue / multiple) * (multiple) + multiple
    End Select
       
    If negNumber = True Then
        wMRound = 0 - result
    Else
        wMRound = result
    End If
End Function

Har du en ide?

I'll take a look as soon as I have a bit of free time.

In your original question you said

"Her ønsker jeg (ligesom MAFRUND-funktionen gør) at den tager de 100 for Varenummer 123 og de 50 for varenummer 1234."

which indicates to me that you want to take TAL from one record and MULTIPLUM from another, is that correct?

Ah, just woken up :-)

Each varenummer has its own MULTIPLUM, its not static.

You can test the code you found by using the Immediate window (debug)

First create a module  for the code you found. Then in the Immediate window (CTRL+G) enter

?wMRound(TAL,MULTIPLUM )

followed by enter. TAL and MULTIPLUM need to be replaced by test data.

You should now see the result. If it works then you can use wMRound in your queries where you replace TAL and MULTIPLUM with fields in table

just tested function wMRound a bit and it seems to work fine :-)

If you need help implementing it then drop a comment.