Search results

I have a query with the following fields extracted from two tables:- ID Activity_type( can be Garbage removal, Tug, Towing, Ship_Chandling) App_num ( approval number for each job done) Ship_Name (name of ship) Cost_of_charge_put (charge for each activity_type) The Ship_Name and App_num(...

I have the folloawing tables:- tblshipmaster with fields( IMO_Num,Ship_Name) tblvoy with fields (Voy_num,IMO_Num) tblquotation with fields(Quotation_Num,Voy_Num) tblapprovequote with fields (App_Num,Quotation_Num) I have relationships set between the tables When I put a query , which I'll...

I have a table called tblapprovedquote with fields App_Num and Quotation_num I have another table tblquotation with fields Quotation_num and Voy_Num Both tables are related in a in a one-to-one relationship . I have a query which pulls fields App_Num , Quotation_num from the tblapprovedquote and...

Please see attached file I have tblShipmaster I have tblshipvoy In the table tblshipvoy , the primary key field is Voy_Num. The IMO_Num field is same as the one in tblShipmaster, so that I can create one to many relationship , different voyage number can have same IMO_Num as a ship can come...

I have a table named tblShipmaster with fields IMO_Num(Primarykey),Ship_Name,Vessel_type. The Vessel_type field picks up value from a lookup field of a table called tblshipcategory I have a related form to enter data in the tblShipmaster, the form is known as frmshipmaster. After a few records...

I have a table named tblShipmaster with fields IMO_Num(Primarykey),Ship_Name,Vessel_type. The Vessel_type field picks up value from a lookup field of a table called tblshipcategory I have a related form to enter data in the tblShipmaster, the form is known as frmshipmaster. After a few records...

Hi I have a table named tblShipmaster with the following fields:_ IMO_Num ( which is the primary key) Ship_Name Vessel_Type Reg_Coun Call_sign I have another table named tblshipvoy with the following fields:- voy_num( the primary key field) IMO_Num Ship_Name Exp_arv_date Exp_dep_date What I...

Hi I am new to access and have little experience working with it . Yes reading through text books and other tutorials are the very steps to acquaint to it , but as a self-starter help from forums of this sort is a real companion to experience the power of Access .More important when you are...

Hi Am using Access 2003. I have created a form. Afterwards I have added a new field to the database structure of the table How do I insert the new field to the form? Thx