Post by SquiggleTag on Jan 26, 2011 10:26:44 GMT -5
Hello Pogotribe.
Long time no see?
Anyways ... i was wondering if anyone could help me?
I'm using Microsoft Access 2007 and i am making a relational Database.
This Database will have 3 tables. (Customer, Items & Orders)
In the orders table there is a field that links to the items table (item no), a table called quantity and another table called total Order cost.
What i need to do is create some sort of formula / macro that will look up the priec of the item in "Item No" on the items table, and then multiply that by the value i entered in Quantity.
Does anyone know what i should do?
Long time no see?
Anyways ... i was wondering if anyone could help me?
I'm using Microsoft Access 2007 and i am making a relational Database.
This Database will have 3 tables. (Customer, Items & Orders)
In the orders table there is a field that links to the items table (item no), a table called quantity and another table called total Order cost.
What i need to do is create some sort of formula / macro that will look up the priec of the item in "Item No" on the items table, and then multiply that by the value i entered in Quantity.
Does anyone know what i should do?
