I'm fairly new to Access and not sure how to approach this problem.
I've table named "Billing" with the following column names:
PrintAccounts = Number of hard copy (paper) invoices (data type = integer)
PDFAccounts = Number of soft copy(PDF) invoices (data type = integer)
CurrentCharge = Monthly usage charge (data type = Currency)
TotalDue = CurrentCharge + Unpaid charge from previous month (data type = Currency) [Note: It will be entered manually]
Duedate = BillDate + (7 to 30 days)
I am wondering if I would able to create a form+subform that would update the "Billing" table.
Form:
Brand:
BillDate:
BillCycle:
Comments:
Subform:
Note:
Groups: Group is the difference between DueDate and BillDate.
Group 1 = If bill is due within 0 to 7 days after BillDate
Group 2 = If bill is due within 8 to 14 days after BillDate
Group 3 = If bill is due within 15 to 21 days after BillDate
Group 4 = If bill is due after 22+ days after BillDate