Access 2013 - Update Table Question

This project is based on a call center making calls to a group of customers every day.
The list of customers to call is replaced daily based on yesterdays business.

I need to be able to track how made the calls along with results and notes.

Looking for the best way to have these details saved in a separate table in order to keep a historical record of this.
I have tried an append query as well as an update query, however it isn't updating the table.

I am asking for some direction here.
* Is the append query the right approach or is there a better way?
* Do I need to do something to select the current record to update the other table?



Thanks!
Dennis
DGWhittakerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rey Obrero (Capricorn1)Commented:
to keep historical records, you should use an Append query that includes a field for date and time.
0
DGWhittakerAuthor Commented:
Thanks Rey!
Any thoughts as to why my append query isn't updating the call log?
I can add the date and time,

Dennis
0
Rey Obrero (Capricorn1)Commented:
@Dennis,
an Append query will not update anything in the table, it will ADD records to the table.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

DGWhittakerAuthor Commented:
Good clarification.
The query is not adding anything to the table, so I assume something is amiss,
Thanks Rey!
Dennis
0
PatHartmanCommented:
If you are running the append query in code and have warnings turned off, turn them back on to see if you are getting an error message that explains the problem.  You can also open the append query in design view and press the view button rather than the run button.  This will show you what data is being selected.  Perhaps your selection criteria is incorrect.
1
Rey Obrero (Capricorn1)Commented:
check the structure of the table you are trying to add records to.
the first one to check is, if there is a field that prevents duplicate to be added.
1

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.