Getting Expression-Relayed Data to Table

[homerj56]

Title sould be "Expression-Related"



I have the following field in a query:

Status1: IIf([Rem_Closed] Is Not Null And [Closed_Date] Is Not Null And [Closed_Name] Is Not Null,"Closed","Open")

I use this in a bound form to auto-populate a text box (called auto_status) to automatically decide if the text box should say "closed" or "open" (based on stated conditions). This works fine.
The problem is that I need to write this status back to the underlying query's field, called "Status", which then gets it back to the underlying table.

Having the field "Status1" in the query is just a calculated field based on conditions but I also need that result written back to the same query's field (called Status).

Any help is appreciated.

[weekend00]

use a update query to save the calculated field.

update tablename set [status]=IIf([Rem_Closed] Is Not Null And [Closed_Date] Is Not Null And [Closed_Name] Is Not Null,"Closed","Open")

[homerj56]

Can I do this in the existing query or do I have to create a new query with just this field?

[weekend00]

create a new one.

[homerj56]

create a new one.

Ok, I'm a bit stumped with this.


NEVER MIND, I figured it out! Thanks.