D digit Registered User. Local time Today, 05:02 Joined Jan 23, 2003 Messages 44 Feb 13, 2003 #1 i have a query with that column - result: [ozp]+[dzp_obshto]+[vv]+[dv]+[ddv] , but when vv or dv is empty i have a empty resut.
i have a query with that column - result: [ozp]+[dzp_obshto]+[vv]+[dv]+[ddv] , but when vv or dv is empty i have a empty resut.
Nouba Registered User. Local time Today, 06:02 Joined Oct 20, 2002 Messages 145 Feb 13, 2003 #2 Use the Nz function on the fields which may contain Null values. i.e. ...+Nz(vv)+Nz(dv)+...
D digit Registered User. Local time Today, 05:02 Joined Jan 23, 2003 Messages 44 Feb 13, 2003 #3 10x 10x
