Copy results in query field to another field

[Lawlee]

Hi there,

I have two fields... a expression named Expr4 and a field called
DayName.

How can I get the result of Expr4 to display in DayName?

Thanks

 

[Joseph Meehan]

Hi there,

I have two fields... a expression named Expr4 and a field called
DayName.

How can I get the result of Expr4 to display in DayName?

Thanks

Do you want to do this for all the records in the table(s) or just one?

I believe I hear an update query calling your name.

 

[Lawlee]

For all the records.

Expr4 is not in a table. i have a weekday function that gets the day
name result and display it in Expr4.

i'm trying to create a left join between two tables, but Expr4 is not
in Text format, but the other field is. So they have to be exactly the
same. Now I want to copy the data which is in Expr4 to a Text formatted
field called DayName.

 

[Joseph Meehan]

For all the records.

Expr4 is not in a table. i have a weekday function that gets the day
name result and display it in Expr4.

i'm trying to create a left join between two tables, but Expr4 is not
in Text format, but the other field is. So they have to be exactly the
same. Now I want to copy the data which is in Expr4 to a Text
formatted field called DayName.

Well I would hope you could work around this so you are not storing the
results of an expression. Is there any reason you want to save this result
in a table? Will you need it for future archive use where some of the
criteria of the expression may have changed and you need to retain the
results as of the earlier data? I don't believe you need to store the
results to express it as a string (text) just use the string function.