Results 1 to 13 of 13
  1. #1
    Mehvan's Avatar
    Mehvan is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2016
    Posts
    133

    Post Customer account statement in detail

    Hello Everyone



    Can I do this in Ms Access for Customer account statement in detail or have another good way in Ms Access We can do it ?

    Click image for larger version. 

Name:	Capture.PNG 
Views:	41 
Size:	17.6 KB 
ID:	36200


    I want Date Field appear only in under Date , and subform details appear under subforms fields whether Sale , Return Sale , stock or other Invoices I want to appear under that subform
    when I enter data in Sale Invoice in subform , data appear under that subform , such as the same photo

    Discount and Net , appear under Main Form

    Click image for larger version. 

Name:	1.PNG 
Views:	39 
Size:	13.8 KB 
ID:	36201

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    that seems correct.
    Yes you want the Invoice Master form, and the detail items in the subform.
    use the Form wizard, it should help you.

  3. #3
    Mehvan's Avatar
    Mehvan is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2016
    Posts
    133
    You mean , I should create new Table the same first photo , and then INSERT data into that new Table with using Append query , right ?

  4. #4
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    no, just use the tables
    the master form shows the master invoice record,,
    the child table , detail items, would be in the subform, and linked to the master form.

    make a query, join the tables,
    a report can show the data properly.

  5. #5
    Mehvan's Avatar
    Mehvan is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2016
    Posts
    133
    I know that , but How All data in will appear in the one table
    because I want (Income Invoice , Sale Invoice , Return Sale Invoice And Stock Invoice ) appear in one table one under other , the same Excel
    I want to create one table , everything related by Customer record there , I will choose the field name .

  6. #6
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Quote Originally Posted by Mehvan View Post
    , but How All data in will appear in the one table because I want (Income Invoice , Sale Invoice , Return Sale Invoice And Stock Invoice ) appear in one table one under other , the same Excel
    It can't. Or shouldn't.


    Quote Originally Posted by Mehvan View Post
    I want to create one table , everything related by Customer record there , I will choose the field name .
    Then you will have to use Excel.
    Understand that Access is not a "bigger" Excel; they are two extremely different animals.

    From your example, you need at least 3 tables: tblInvoices, tblInvoiceDetails and tblOroducts

  7. #7
    Mehvan's Avatar
    Mehvan is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2016
    Posts
    133
    yes , you're right , something Excel can do and Access can't do it , and Access the same sometimes
    I think , I need one table for those Tables , for example : when I enter data in SaleInvoice , must I have button like btnSave , when I click on , INSERT DATA INTO that Table , and UPDATE Button the same .
    Is this way will be good ?

  8. #8
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    I'm not sure you understand the differences between Access and Excel yet.

    You should work through the tutorials at http://www.rogersaccesslibrary.com/forum/forum46.html, then design your dB..... shouldn't take you too long...

  9. #9
    Mehvan's Avatar
    Mehvan is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2016
    Posts
    133
    thanks a lot for all of you , we can say Access can't do that

  10. #10
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Quote Originally Posted by Mehvan View Post
    we can say Access can't do that
    Uhhh.... Access can "do that", but there must be a valid table/relationship design and VBA programming would be needed.
    I will concede that Access can't "do that" if stuck in an Excel mind set.

  11. #11
    Mehvan's Avatar
    Mehvan is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2016
    Posts
    133
    Do you have a solution to this problem I have?
    Do you have another idea for it , instead of the second table to insert and update data ?
    I think the second table is good to solve this problem even I find better solution , isn't it ?

  12. #12
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    You have shown what you are doing in Excel, but you haven't described what your business is. Maybe you would write 8 - 10 sentences to describe your business.


    Looking at the Excel example in Post #1, I think there would be at least 4 tables.
    tblCustomers
    tblProducts
    tblOrders
    tblOrder_Details.

  13. #13
    Mehvan's Avatar
    Mehvan is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2016
    Posts
    133
    I know , and I have 4 tables , but here I need to use INSERT INTO and UPDATE for these tables INTO one table
    I think this way it will be useful for me .
    thanks a lot for stayed with me till now .

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

Similar Threads

  1. Age Analysis on Customer Statement
    By Freddie81 in forum Reports
    Replies: 14
    Last Post: 09-26-2018, 06:13 PM
  2. Account Statement Report
    By Freddie81 in forum Reports
    Replies: 1
    Last Post: 07-25-2018, 09:45 AM
  3. Customer Account Database
    By Bold in forum Database Design
    Replies: 11
    Last Post: 03-18-2018, 11:13 PM
  4. Replies: 5
    Last Post: 06-25-2014, 12:29 PM
  5. Replies: 6
    Last Post: 12-11-2013, 09:27 PM

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