Lesson 4 Sums Returning Errors - How To Build a Complete Check Register With Multiple Accounts, Printing, Reports, and Charts in Microsoft Access

25 minutes ago: Please note that the webserver will soon get its weekly reboot at 4:00 am Eastern Time. You may continue to use the site as normal, but you will be logged off at that time. You should be able to log right back on immediately, however. If you are in the process of placing an order, please make sure to complete it as quickly as possible, or come back after the reboot. Thank you. Sorry for any inconvenience. Dismiss

Free Lessons
Courses
Seminars

TechHelp
Fast Tips
Templates

Topic Index
Forum
ABCD

Home Courses TechHelp Help Contact Merch Join Order Logon Forums


	Back to Check Register Seminar Lessons Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Lesson 4 Sums Returning Errors

Tannim Hallman

13 months ago

On the CheckRegBatchPrintF, Debit and ToBePrinted both work. The sum fields in the footer don't. They only return #Error. I have tried copy/paste of the original field and changing the record source to =sum(debit). I have tried deleting the sum text boxes, and re-doing them. I have copy/pasted the sumdebit field from CheckRegF. I am at a complete loss.

	Tannim Hallman OP @Reply 13 months ago

	Tannim Hallman OP @Reply 13 months ago

	Raymond Spornhauer @Reply 13 months ago
Tannim Another user recently had this same problem. They deleted the text box in the footer and re-added it and it worked. I would also suggest making sure the data type and format for the text box is set to 'currency'. Hope this helps. -Raymond

	Tannim Hallman OP @Reply 13 months ago
And this time it worked. Thanks, Raymond.

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