Report doesn't open

[endri81]

Hi I builded a report based on the query as in picture attached.
GjendjaFamiljare is 0 = Single,1=Married,2=Divorced,3=Widowed.
My report works fine for this value but I need to add another 4=N/A where is described data missing(the user does't fill this value)
How to make this happen?
Thx

 

[John Big Booty]

Check out the Nz() function. You could have an expression in your query along the lines of;

Nz([GjendjaFamiljare],4)