the table that this Update Query is supposed to modify ("Automobile_Info") contains the three fields "Suite", "FirstName_1", and "LastName" (among others).
there is a linked table ("tblautoinfo") which the Update Query is getting it's modifying data from, which also contains those fields. i only list those three fields because they're the only ones relevant to my problem.
when running the Update Query, all data from "tblautoinfo" is transferred from "tblautoinfo" to "Automobile_Info"), except for one very strange occurrence:
in all 162 records being updated in "Automobile_Info", the "FirstName_1" and "LastName" fields are being populated with the suite number from the "Suite" field. i can't, for the life of me, figure out why it's doing this. i have checked, re-checked, and triple-checked the Update Query in design view, and it is absolutely laid out correctly, all fields from "tblautoinfo" being correctly mapped to their respective fields in "Automobile_Info", yet the Suite number is still replacing whatever is in "FirstName_1" and "LastName". i've tried copying/pasting the data from the "FirstName_1" and "LastName" fields directly from "tblautoinfo" to "Automobile_Info", but no changes are made when doing so. manually changing the data works fine, but once the Update Query is run, the Suite number is again populating those fields.
this is probably the strangest thing i've run into so far in my time with Access 2007.
if you need any extra information, please let me know and i'll supply it to the best of my ability, but i'm completely at a loss on this one. any help is most definitely appreciated.
there is a linked table ("tblautoinfo") which the Update Query is getting it's modifying data from, which also contains those fields. i only list those three fields because they're the only ones relevant to my problem.
when running the Update Query, all data from "tblautoinfo" is transferred from "tblautoinfo" to "Automobile_Info"), except for one very strange occurrence:
in all 162 records being updated in "Automobile_Info", the "FirstName_1" and "LastName" fields are being populated with the suite number from the "Suite" field. i can't, for the life of me, figure out why it's doing this. i have checked, re-checked, and triple-checked the Update Query in design view, and it is absolutely laid out correctly, all fields from "tblautoinfo" being correctly mapped to their respective fields in "Automobile_Info", yet the Suite number is still replacing whatever is in "FirstName_1" and "LastName". i've tried copying/pasting the data from the "FirstName_1" and "LastName" fields directly from "tblautoinfo" to "Automobile_Info", but no changes are made when doing so. manually changing the data works fine, but once the Update Query is run, the Suite number is again populating those fields.
this is probably the strangest thing i've run into so far in my time with Access 2007.
if you need any extra information, please let me know and i'll supply it to the best of my ability, but i'm completely at a loss on this one. any help is most definitely appreciated.