I am making a project comprising following 6 tables-

(1)ReleasedOrderDetails
ReleasedOrderNo(primary key)
Other Fields

(2)ReceiptRegister

ReleasedOrderNo(Foreign key)
OrderedWt
Other Fields

(3)DDDetails

DDNo(primary key)
DDAmount
Other Fields

(4)BillDetails


BillNo (primary key)
BillAmount
BillQuantity
Other Fields

(5)ROBill


BillNo (Foreign key)
ReleasedOrderNo (Foreign key)

(6)RODD


DDNo (Foreign key)
ReleasedOrderNo (Foreign key)

Is there any single SQL command which can give
sum(DDAmount),sum(BillAmount),
sum(DDAmount)-sum(BillAmount),
sum(OrderedWt), sum(BillQuantity),
sum(OrderedWt)-sum(BillQuantity) ?

If yes then how can I use it in VB DataReport?
Please guide me?

you can u create the single query/view/cursor use in the datareport