Using Nz function

Formentlig fordi værdien bliver opfattet som tekst.

Måske virker:

Dim a as string
Dim b as string

a="222"  'er tekst
b="333"  'er tekst

debug.print a+b    'giver 222333
debug.print cdbl(a) + cdbl(b)  'giver 555
Du kan også bruge andre konverteringsfunktioner: cLng, cSng, cInt

Problemer er nok at nz() funktionen returnerer tekst i stedet for tal.

Har dog ikke testet ovenstående.

Is there other ways to get the result 0(zero)if no matches are found in a query and that does'nt change the property to text?

I think so. Is it a regular query?
Or are you using SQL via VBA?
Can you show a piece of the code?

One example is:
Me.Taxkredit = Nz((DSum("DEBITERAS", "Resapost", "(Resapost.SlutDat Between Forms.Rapport.StartDag And Forms.Rapport.SlutDag) And (Resapost.Taxinr = Forms.Rapport.Taxinr) And (Resapost.ARBPASSNR = Forms.Rapport.Rapport) And (Resapost.FORAR_ID = Forms.Rapport.Forarnr) And (Resapost.KREDITTYP > 3)")) - (DSum("DRICKS", "Resapost", "(Resapost.SlutDat Between Forms.Rapport.StartDag And Forms.Rapport.SlutDag) And (Resapost.Taxinr = Forms.Rapport.Taxinr) And (Resapost.ARBPASSNR = Forms.Rapport.Rapport) And (Resapost.FORAR_ID = Forms.Rapport.Forarnr) And (Resapost.KREDITTYP > 3)")), 0)

Not quite sure I understand the problem, you should use NZ on each field in the calculated value. If a field is NULL (which is not the same as 0 (zero)) then nz can be sued to return a value for example 0. Otheriwse your calculation is going to fail if one field is NULL and others arent.

Hope you understand that.

That's quite a long Dsum.
Usually using nested aggregate functions (dsum,dlookup etc) can slow the form down.
If the purpose is to display a number in a text field I'd consider doing it via VBA that runs on the forms current_event. It'll be much quicker.

Does something like this work?:

Me.Taxkredit = Format(Cdbl(Nz((DSum("DEBITERAS", "Resapost", "(Resapost.SlutDat Between Forms.Rapport.StartDag And Forms.Rapport.SlutDag) And (Resapost.Taxinr = Forms.Rapport.Taxinr) And (Resapost.ARBPASSNR = Forms.Rapport.Rapport) And (Resapost.FORAR_ID = Forms.Rapport.Forarnr) And (Resapost.KREDITTYP > 3)")) - (DSum("DRICKS", "Resapost", "(Resapost.SlutDat Between Forms.Rapport.StartDag And Forms.Rapport.SlutDag) And (Resapost.Taxinr = Forms.Rapport.Taxinr) And (Resapost.ARBPASSNR = Forms.Rapport.Rapport) And (Resapost.FORAR_ID = Forms.Rapport.Forarnr) And (Resapost.KREDITTYP > 3)")), 0)),"0.00")

Terry, I want 0 as the result if no records are found that meets the criteria.
jesperfjoelner, i will try and see if it works.

The suggestion from You, jesperfjoelner, seems to work if it just is a matter of displying a nbr in a text field, but the value is stored for later calculations. What happens then?

I seems to work even in later calculations.
Does this method work faster then the Nz function?

Forget about the last question. It's of course still a Nz function.
What happens is that the value from DRICKS is deducted from the value from DEBITERAS. Both values should meet the same criteria. Is it possible to simplify the code?

Mange tak :-)