Access database help pleaseeeeee

[S08]

Can someone here help me with access database?

[SID_NY]

Access is still alive? What you need help with?

[S08]

Salam SID, yes unfortunately

[S08]

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.

[SID_NY]

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.

[SID_NY]

Once the new tables are created let me know if you need help with form query

[S08]

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

[S08]

And what would be datatype?

[SID_NY]

I PMed you with the followup