I know this must be easy!

[C2680mor]

I don't normally work in access so I am sure I am asking a really easy question.

I have a table that is connected to a form where users enter survey data. Currently they have a drop down form to mark the responses to the survey as "Fully Completed", "Partly Completed", etc.

On the table I want to add the text "Awaiting Completion" to all those without any entry so that we can find out how many are left to do.

I can filter the table to give me the correct records, and assumed I could paste the text directly into the column (as with Excel).

Can anyone please let me know how to update the column easily.

Thanks for your advice.

Chris

 

[neileg]

You can use an update query to add the text you want. Otherwise, just filter on records with no text in this field. Surely this is enougth?

 

[C2680mor]

Thanks the update query has worked.

Chris.