populate a field depending on the value of another

[neilwebber]

Hi everyone,
I have a table with a yes/no field (Confidential) and I want to populate another field (Confidential Text) with a set text ("this is a confidential file") if the yes/no field is true, or else leave blank. I'm sure it must be obvious but I'm a new user and still finding my way. Hope you can help
cheers
Neil

 

[thouston]

Make a query selecting the yes/no field and the text field. Turn the default "select" query to an "update" query (It's on the toolbar or in the Query menu). Put yes (with no quotes round it) in the criteria row for the yes/no field and "this is a confidential file" (with quotes) in the "Update to" row for the text column. This will update all the yes rows and leave the no rows as they were.

Good luck!

 

[cogent1]

Eh?.....

If you have a check box to indicate that the file is confidential, why do you need to store repetitive text, which performs the same function, in your table ?

 

[neilwebber]

Sorry for not tying up this thread - been away for a while. I've sorted it now - thanks for your suggestion thouston. Cogent - I can't answer your question - its confidential