Case Statement for a blank Field

[TechRangerBrad]

So I have some fields in my table that are blank, and am trying to write a case statement that would replace the blank field with a value of "Null".

Is the case statement the best way to do this?

[Lee Smith]

Why?

Assuming that the Field is a Text field, and not an number, date, or Calculation, I would use the Menu Replace Function.

If this is a calculation Field that you want to default to Null, then stop here, and let us know.

Otherwise;

First isolate the records to be changed.

Enter Find Mode

Type = in the field that you want to change (the equal sign = will find records with where that field is blank)

Next, Put the cursor in the field to be change and type in Null

Next;

Go to Menu >> Format >> Replace

Click on Replace

All the records in the found set should now contain the word Null in the field.

HTH

[TechRangerBrad]

Thank you for the response. I have grades coming in on a sql query. Some grades have the actual grade field empty. I need to put the value of "Null" in there so my other calculation fields will execute correctly. I would prefer the end user not attempt a find and replace.

[Lee Smith]

I would then use a Auto Enter by Calculation on the field

Something like;

Highlight the field in Define Fields, and click on the options. Click on the Auto Enter Tab (should already be there as the default)

Click on the "Calculated Value"

Enter "Null"

Click Okay,

Deselect the checkbox

"Do not replace existing value of Field (if Any)"

Click Okay.

New Record should now have Null in that field. If you are importing this data, you will want to click the option to Perform the Auto Enter Options while importing.

HTH

Lee