D
DDD
In table 1 there are records of cars (field 1 is name), & the cost of each 1
(this is field 2). In table 2, this is the sales. this includes the car name
field, quantity field & cost. The quantity field does not represent the
number of cars available, its to show how many the person wants to buy. the
cost represents the cost of 1 car multiplied by the quantity (how many they
want to buy)
As you can see. a sale record can only hold 1 car name. if a customer wants
to buy 2 completely different cars, this is treated as 2 different sales.
How do you create a query that will calculate this cost i have mensioned for
the sales table.
can any1 provide clear simple instructions on how to achieve this
(this is field 2). In table 2, this is the sales. this includes the car name
field, quantity field & cost. The quantity field does not represent the
number of cars available, its to show how many the person wants to buy. the
cost represents the cost of 1 car multiplied by the quantity (how many they
want to buy)
As you can see. a sale record can only hold 1 car name. if a customer wants
to buy 2 completely different cars, this is treated as 2 different sales.
How do you create a query that will calculate this cost i have mensioned for
the sales table.
can any1 provide clear simple instructions on how to achieve this