| URGENT: Calculation query [message #317788] |
Sat, 03 May 2008 11:27  |
himesh
Messages: 5
Registered: May 2008
|
Junior Member |
|
|
Hi
I have left my coursework to the last minute and really need your help!
I have created multiple tables and have input data into them, now i have to query one table and perform a vat calculation on one field, the vat value has to be inputted into one of the fields and then the vat taken from the gross total to form the net total, does anybody have a clue how to do this?
this is my table structure
CREATE TABLE Client_orders
(Order_number SMALLINT,
Order_date DATE,
Order_time SMALLINT,
LTC_staff_number SMALLINT,
Client_staff_number SMALLINT,
Discounted_amount NUMERIC(7,2),
Net_order_total NUMERIC(7,2),
VAT NUMERIC(7,2),
Gross_order_total NUMERIC(7,2),
CONSTRAINT Co_pk PRIMARY KEY (Order_number));
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
