I am creating a database of receipts for credit cards and I want to use the check box to only select those receipts that appear on the current bill as the bill comes due. I want a total of the checked items and a total of the not checked items and then a grand total of both. I started with the ESTIMATES Template and have been renaming and re-imagining the template. I just don't know how to write the calculation for these fields. I have Estimates Data and Estimates as the main tables. I put the Check Box in Estimates Data fields and the totals appear in the ESTIMATES fields.
Once I get this to be right, I want to produce a list from just the check box items, which will match my bill and those items no longer need to appear in my list because they are paid. The remaining items will stay until I place an X in the check box and start the whole process again.
Can someone help?