Hi I have not made any queries yet for my system so this probably help for that aswell however I need some help with making a chart,
I have four tables named
tblCustomerDatabase
with the following attributes
*CustomerID
Title
Full Name
Address1
Address2
Country
Telephone Number
E-mail Address
tblCargoDetails
With the following attributes
*CargoID
Type Of Handling
CargoPrice
CustomerID
DescriptionOfCargo
DateOfOrder
MonthOfOrder
Year
tblAirFreight
*PlaneID
Name Of Plane
CargoID
AirplaneCompany
Cargo Destination
Airport Of Discharge
Airport Of Receival
tblSeaFreight
*ShipID
Name Of Vessel
CargoID
Shipping Company
Cargo Destination
Port Of Discharge
Port Of Delivery
What I would like to be able to do is to be able to have the system ask what year you want (eg. 1998) and then all the the system to add up all the order prices (from CargoPrice)for each month of that year and produce chart for all the sales that year, can anyone spead some light on this problem I have no idea on how I am going to do this or if I have to do it with a query first I just don't know can you help me please? Thank you very much.
I have four tables named
tblCustomerDatabase
with the following attributes
*CustomerID
Title
Full Name
Address1
Address2
Country
Telephone Number
E-mail Address
tblCargoDetails
With the following attributes
*CargoID
Type Of Handling
CargoPrice
CustomerID
DescriptionOfCargo
DateOfOrder
MonthOfOrder
Year
tblAirFreight
*PlaneID
Name Of Plane
CargoID
AirplaneCompany
Cargo Destination
Airport Of Discharge
Airport Of Receival
tblSeaFreight
*ShipID
Name Of Vessel
CargoID
Shipping Company
Cargo Destination
Port Of Discharge
Port Of Delivery
What I would like to be able to do is to be able to have the system ask what year you want (eg. 1998) and then all the the system to add up all the order prices (from CargoPrice)for each month of that year and produce chart for all the sales that year, can anyone spead some light on this problem I have no idea on how I am going to do this or if I have to do it with a query first I just don't know can you help me please? Thank you very much.