Glenn Lieding
Registered User.
- Local time
- Yesterday, 19:41
- Joined
- Feb 5, 2013
- Messages
- 11
I have a Query involving calculated Field expressions that works fine in Select mode but not when run as an Append Query (without any other modifications). When run as an Append Query, Access treats the fields as parameters and asks for their values (and then delivers incorrect results, of course).
That's just WRONG! :banghead:
The Field expressions that don't work in Append mode seem to be the ones that use other Field expressions. For example:
Field: is_lang_match: ([n_lang_id_1]=[n_lang_id_2])
Field: is_lang_id_1: Language_ID
Table: First_Name_Usages
Field: is_lang_id_2: Language_ID
Table: First_Name_Usages_1
I suppose I could decompose all such expressions into ones only involving primary references to Table Fields. However, some of them would become quite long, complicated, hard to understand, and hard to maintain, especially in that tiny little box in Query Design (I wish there were an Expression Builder pop-up there!).
I just seems to me that it is just plain WRONG! that Access should run a Query differently when it is converted to an Update Query (other than that it should append records, of course!).
Very frustrating. I would appreciate any help you could offer. Thank you.
That's just WRONG! :banghead:
The Field expressions that don't work in Append mode seem to be the ones that use other Field expressions. For example:
Field: is_lang_match: ([n_lang_id_1]=[n_lang_id_2])
Field: is_lang_id_1: Language_ID
Table: First_Name_Usages
Field: is_lang_id_2: Language_ID
Table: First_Name_Usages_1
I suppose I could decompose all such expressions into ones only involving primary references to Table Fields. However, some of them would become quite long, complicated, hard to understand, and hard to maintain, especially in that tiny little box in Query Design (I wish there were an Expression Builder pop-up there!).
I just seems to me that it is just plain WRONG! that Access should run a Query differently when it is converted to an Update Query (other than that it should append records, of course!).
Very frustrating. I would appreciate any help you could offer. Thank you.