C
Cat
Heya all - I'm trying to create an update query - first thing I did was create the selection criteria, which appears to be working just fine
Field: FullNam
Table: TBL: Additional Part 2 Dat
Criteria: [TBL: Registration ALL]![FullName
That grabs only stuff from Registration ALL where field FullName matches field FullName in Part 2 Data table. (Right?
Now, I want to update several fields in the Registration ALL table with the values of fields in the Part 2 Data table
I tried the following
Field: FlyingorDrivin
Table: Registration AL
Update To: [TBL: Additional Part 2 Data]![FlyingorDriving
When bringing this up in datasheet view, it just lists blank, when I know there to be a value in that field in Part 2 data for the selected records
Did I just mess up the syntax or such? Strangely, when I save the query and enter it again, the contents of that Update To: row change to [TBL: Additional Part 2 Data]!FlyingorDriving - (brackets around FlyingorDriving disappear
Any idea what I'm doing wrong? Thanks so much!!!!
Field: FullNam
Table: TBL: Additional Part 2 Dat
Criteria: [TBL: Registration ALL]![FullName
That grabs only stuff from Registration ALL where field FullName matches field FullName in Part 2 Data table. (Right?
Now, I want to update several fields in the Registration ALL table with the values of fields in the Part 2 Data table
I tried the following
Field: FlyingorDrivin
Table: Registration AL
Update To: [TBL: Additional Part 2 Data]![FlyingorDriving
When bringing this up in datasheet view, it just lists blank, when I know there to be a value in that field in Part 2 data for the selected records
Did I just mess up the syntax or such? Strangely, when I save the query and enter it again, the contents of that Update To: row change to [TBL: Additional Part 2 Data]!FlyingorDriving - (brackets around FlyingorDriving disappear
Any idea what I'm doing wrong? Thanks so much!!!!