Skip to main content
Database Administrators

Return to Question

Question Protected by CommunityBot
Tweeted twitter.com/StackDBAs/status/1173929740199256065
Noise reduction; layout.
Source Link
edit approved Sep 17, 2019 at 10:22
Dharman
edit approved Sep 17, 2019 at 10:22
Dharman
  • 105
  • 5

I am in need of a query string assistance please.

I am working with a DB in Access and I'd like to be able to fill the field in this row with a result of SINGLE if it is not already filled with another value.

I wrote Iif(MaritalStatus) is null, "SINGLE") but Access returned a result in which all of the fields were filled with SINGLE except those that had had a previous value of Married, Divorced, etc.

Your help is appreciated.

I am in need of a query string assistance please.

I am working with a DB in Access and I'd like to be able to fill the field in this row with a result of SINGLE if it is not already filled with another value.

I wrote Iif(MaritalStatus) is null, "SINGLE") but Access returned a result in which all of the fields were filled with SINGLE except those that had had a previous value of Married, Divorced, etc.

Your help is appreciated.

I am working with a DB in Access and I'd like to be able to fill the field in this row with a result of SINGLE if it is not already filled with another value.

I wrote Iif(MaritalStatus) is null, "SINGLE") but Access returned a result in which all of the fields were filled with SINGLE except those that had had a previous value of Married, Divorced, etc.

Corrected title
Link
edit approved Aug 5, 2014 at 6:27
Pieter Geerkens
edit approved Aug 5, 2014 at 6:27
Pieter Geerkens
  • 2k
  • 13
  • 21

IF NOTIS NULL then SINGLE else keep the value of the field

Source Link
Trish Main
Trish Main
  • 41
  • 1
  • 1
  • 3

IF NOT NULL then SINGLE else keep the value of the field

I am in need of a query string assistance please.

I am working with a DB in Access and I'd like to be able to fill the field in this row with a result of SINGLE if it is not already filled with another value.

I wrote Iif(MaritalStatus) is null, "SINGLE") but Access returned a result in which all of the fields were filled with SINGLE except those that had had a previous value of Married, Divorced, etc.

Your help is appreciated.