I have a table with three columns

Column A, Column B, Column C

in these 3 columns i have different values and in two fo these columns there are blanks. I want to search for this blanks and fill them in with a static value. But only the two columns.
How can i do this? Update Queries?

Thanks you

Update queries.

Remember to back up your data first.

In the criteria for these columns, add this:

Is Null Or = ""

This will pull all the empty records. Do this one Column at a time since there may be a case where there is something in Column B, and nothing in Column C, and that may update Column B.

Anyway, then add whatever value you want in the To: line, and then click the ! to run the query.

Did that work?


mmcdonal

No it did not work and i tried one column at a time..

Try to build a select query that shows only those records with blanks in Column B to start with, and then post your SQL.

mmcdonal

this is the SQL i get on the update query..

UPDATE Append_Working SET Append_Working.Debits = "\fp"
WHERE (((Append_Working.Debits) Is Null Or (Append_Working.Debits)=""));