Can someone here help me with access database?
Access is still alive? What you need help with?
Salam SID, yes unfortunately
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 = FeeRatequantity
SurchargeFee = FeeDue0.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.
Restored attachments:
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.
Once the new tables are created let me know if you need help with form query
And what would be datatype?
I PMed you with the followup