Copying existing Excel Data - How To Build a Complete Check Register With Multiple Accounts, Printing, Reports, and Charts in Microsoft Access


	Back to Check Register Seminar Lessons Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Copying existing Excel Data

John Schulte

5 years ago

How does a person copy existing transaction from Excel to Checkbook and still have the Query calculated fields accurate? Seems like the first two rows wont calculate.

	Richard Rost @Reply 5 years ago
Perform an import from Excel directly into the table. Then the query should work.

	John Schulte OP @Reply 5 years ago
No matter what I do, if I import into the CheckRegT, the calculated fields wont populate only those records. Any records I type in for example opening balances, will calculate in all three fields. I've imported number fields as number fields. Will continue on with rest of the lessons as they are really good stuff!

	Richard Rost @Reply 5 years ago
That's strange. As long as you import into the Debit and Credit fields, the Amount and other calculated fields should update. The form is based on a query which does the calculations. I just tried it and it worked fine for me.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Check Register Seminar Lessons.

Next Unseen

New Feature: Comment Live View