Results 1 to 2 of 2
  1. #1
    ish is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2015
    Posts
    1

    Access multidimensional subform

    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

  2. #2
    NTC is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2009
    Posts
    2,392
    right now if there is only 1 table then you would only have 1 form, no sub form - and the data would simply repeat in fields
    Brand:
    BillDate:
    BillCycle:
    Comments:

    Otherwise you want to split that table into 2 tables a Parent:Child or 1:Many relationship and have the 4 key fields above in the parent, and then the other fields in the child....linked together by a Parent autonumber primary key field....when you have those 2 tables then the form/subform approach will work.


Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 10
    Last Post: 04-25-2014, 12:53 PM
  2. Access subform
    By samsonr1 in forum Access
    Replies: 1
    Last Post: 04-23-2014, 07:15 PM
  3. Replies: 6
    Last Post: 12-03-2012, 05:28 PM
  4. Refresh subform in access 2010
    By lkates in forum Access
    Replies: 4
    Last Post: 07-23-2012, 01:00 PM
  5. MS Access - Subform
    By Milan25 in forum Programming
    Replies: 2
    Last Post: 02-10-2011, 10:59 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums