Can someone here help me with access database?
Announcement
Collapse
No announcement yet.
Access database help pleaseeeeee
Collapse
X
-
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
-
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
Comment