View Single Post
Old October 30th, 2003, 11:24 AM
PamS PamS is offline
Registered User
Join Date: Oct 2003
Location: , , .
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts

OK - I am importing two reports that are missing two depts. During the import I create records for these depts and then want the user to key in the rest of the info (dollar amts). The key to file A is "A" + Dept + Date and the key to file D is "D" + Dept + Date, the only difference is the A or D. I made two tables because I have to subtract the "D" amts from the "A" amts for a report. (ALL minus DEBITs gives me CREDITS.) When the user keys in the amts I would like to update both tables. The entry form only shows the two missing depts. Should I create an append query to run after the form, or can I do an update query using data from one table to update the other table?