Announcement

Collapse
No announcement yet.

Access database help pleaseeeeee

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Access database help pleaseeeeee

    Can someone here help me with access database?

    #2
    Access is still alive? What you need help with?
    Attitude is more important than facts.
    "Life is 10% what happens to us..and 90% of how we react to it"

    Comment


      #3
      Salam SID, yes unfortunately

      Comment


        #4
        Click image for larger version

Name:	Capture.PNG
Views:	14
Size:	18.2 KB
ID:	16691235


        SO this is my customer table.

        They send monthly receipt to our company with this info: Quantity, ReceiptDate, TotalPaid, PaymentMethod(check #), and BounceCheck(text field)

        And then our company calculate how much they owe us PaymentDue: FeeDue, SurchargeFee, TotalDue, Balance

        Calculation needs to be done automatically like this:

        FeeDue = FeeRate*quantity
        SurchargeFee = FeeDue*0.075
        TotalDue = FeeDue+SurchargeFee
        Balance = TotalDue-TotalPaid


        I need to create 2 more tables from above information but how do I link it. Its going to be one to one relationship. Its standalone database.

        Comment


          #5
          can you add the column first and then move it to separate table?

          https://support.microsoft.com/en-us/...ion%20Builder.


          The new tables will be designed by you. That is, a pick a primary key, cross reference to the current table and add the calculated column in there.
          Attitude is more important than facts.
          "Life is 10% what happens to us..and 90% of how we react to it"

          Comment


            #6
            Once the new tables are created let me know if you need help with form query
            Attitude is more important than facts.
            "Life is 10% what happens to us..and 90% of how we react to it"

            Comment


              #7
              SID, what fields do I add to link each other?

              Click image for larger version

Name:	Capture 2.PNG
Views:	11
Size:	7.7 KB
ID:	16691244Click image for larger version

Name:	Capture 3.PNG
Views:	11
Size:	9.6 KB
ID:	16691245Click image for larger version

Name:	Capture 4.PNG
Views:	11
Size:	6.9 KB
ID:	16691246

              Comment


                #8
                And what would be datatype?

                Comment


                  #9
                  I PMed you with the followup
                  Attitude is more important than facts.
                  "Life is 10% what happens to us..and 90% of how we react to it"

                  Comment

                  Working...
                  X