GregoryWest
Registered User.
- Local time
- Yesterday, 21:44
- Joined
- Apr 13, 2014
- Messages
- 161
I am trying to write an update query. There are 1/2 dozen to a couple dozen fields in the various tables in question. The raw data is sitting in an access table with 4 fields:
ID automatic ID
Text1 Char(255) first half of the import files line
Text2 Char(255) second half of the import files line
There are queries called rawdata_01 (to 06) that calls up this table and adds a calculated field:
RecType Number(2) defined as =mid(text1,14,2) and a condition (= 1 to 6))
The update to the working tables updates each field with the 'update to:' set to a series of mid statements that look like: Mid(([RawData_01]!InputText),1,3)
My problem is instead of updating the data in the working table, Access is asking me for the value of RawData_01!InputText
What am I doing wrong? Or is what I am trying to do not possible.
Now, just a caviot, please don't ask me about changing the raw data as I do not control the source in any way. I am sent a flat text file of several thousand records with one of 6 different record structures possible for each individual line.
ID automatic ID
Text1 Char(255) first half of the import files line
Text2 Char(255) second half of the import files line
There are queries called rawdata_01 (to 06) that calls up this table and adds a calculated field:
RecType Number(2) defined as =mid(text1,14,2) and a condition (= 1 to 6))
The update to the working tables updates each field with the 'update to:' set to a series of mid statements that look like: Mid(([RawData_01]!InputText),1,3)
My problem is instead of updating the data in the working table, Access is asking me for the value of RawData_01!InputText
What am I doing wrong? Or is what I am trying to do not possible.
Now, just a caviot, please don't ask me about changing the raw data as I do not control the source in any way. I am sent a flat text file of several thousand records with one of 6 different record structures possible for each individual line.