I am lost and would appreciate anyone's help!!
I have to make my current access database do billing. In theory that would
be a * b = c, but I have a lot of variables and no idea how to program this
to make it work.
Table 1 - Rate Table
Customer Rate Commodity
ABC Co $225 Twine
ABC Co $500 Burlap
Widget Inc $200 Plywood
Table 2 - Inventory
Customer Warehouse Receipt Description
ABC Co 113456 Treated Burlap Squares
I need to have a query or a report be able to know that the charge for
warehouse receipt #113456 is $500 and I have no idea how to get from this
info to access knowing that answer. If there were only one option per
customer, I could figure it out but since there will be multiple rates per
customer depending on the commodity, I have no idea how to get Access to
recognize the commodity from the description in the Inventory table and then
report that info back out onto an invoice.
Anyone have any ideas??
Thanks so much for your time!
Christine
--
Message posted via http://www.accessmonster.com