The new forums will be named Coin Return (based on the most recent vote)! You can check on the status and timeline of the transition to the new forums here.
The Guiding Principles and New Rules document is now in effect.
Access Database help!
R0land1188
Registered User regular
Registered User regular
I am trying to program a form/subform in a database for a recycling center.
I have a main form which contains next to no information of necessity to my question, but is basically to create a Purchase Order and Receipt.
The subform has information with a date, product ID, rate, weight, and subtotal. I need it to find a rate in a separate table based off of the date & ID, and multiply that rate with the weight to get a subtotal.
If anyone would be willing to point me in the right direction I would appreciate it, I just have no idea at the moment where to even begin.
EDIT: I had an epiphany, I was seriously over thinking the issue. I setup a rates sheet that updates the table with the proper information.
I have a main form which contains next to no information of necessity to my question, but is basically to create a Purchase Order and Receipt.
The subform has information with a date, product ID, rate, weight, and subtotal. I need it to find a rate in a separate table based off of the date & ID, and multiply that rate with the weight to get a subtotal.
If anyone would be willing to point me in the right direction I would appreciate it, I just have no idea at the moment where to even begin.
EDIT: I had an epiphany, I was seriously over thinking the issue. I setup a rates sheet that updates the table with the proper information.
R0land1188 on
0
Posts