Replacing data in a field.

[darrellx]

I have a price sheet that has many blank price fields. I would like to replace these empty record fields with "POR" when the price field is blank.

I think that I do this with an if then query but am not sure how to do it.

Any help is appreciated.

Thanks in advance

darrellx

[ajetrumpet]

use the find and replace dialog in the table, or in a query write:

UPDATE table SET table.field = 'POR' where table.field IS NULL

[Bob Fitz]

Hi

I have a price sheet that has many blank price fields. I would like to replace these empty record fields with "POR" when the price field is blank.

This can be done with an Update query. Take a look at that and if you need more help, post back.

To get "POR" entered with all new records I would set the Default property for the field at table level. I would also use a little code to validate the field's value in the Before Update property of the form in which new records are created.

[darrellx]

That was easy enough. Thanks

[RuralGuy]

I would think that the Price field would be a numeric field and "POR" is a string (text). You could easily cause the field to be displayed on a Form/Report as "POR" when there is no value. I would not recommend that you set this field as Text however since you would almost certainly want to use it in a calculation somewhere else in the system.