As was foretold, we've added advertisements to the forums! If you have questions, or if you encounter any bugs, please visit this thread: https://forums.penny-arcade.com/discussion/240191/forum-advertisement-faq-and-reports-thread/
We're funding a new Acquisitions Incorporated series on Kickstarter right now! Check it out at https://www.kickstarter.com/projects/pennyarcade/acquisitions-incorporated-the-series-2
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