D
DucateAssignment via AccessMonster.com
Can someone help me?
I am trying to set up an update query to update data in two tables. On the
first table called downinfo, I need to update 3 fields of 7 fields. The
first named CDCnum, second named InmateNAME and the third named InmateHOUSING.
I am importing a txt file with new information I would like to use in the
update query. The table also has DucateTIME, DucatDATE, DucatREASON, and
DucatTO as fields with data that needs to be deleted.
The second table is named AM PM Ducats. I have CDCnum, InmateNAME, and
InmateHOUSING as well that need to be updated. The remaining fields need to
remain unchanged.
I have no idea on how this works. I would greatly appreciated any assistance.
I am trying to set up an update query to update data in two tables. On the
first table called downinfo, I need to update 3 fields of 7 fields. The
first named CDCnum, second named InmateNAME and the third named InmateHOUSING.
I am importing a txt file with new information I would like to use in the
update query. The table also has DucateTIME, DucatDATE, DucatREASON, and
DucatTO as fields with data that needs to be deleted.
The second table is named AM PM Ducats. I have CDCnum, InmateNAME, and
InmateHOUSING as well that need to be updated. The remaining fields need to
remain unchanged.
I have no idea on how this works. I would greatly appreciated any assistance.