Report not picking up all data Nic Steele 27.09.2006 16:56:01 My report is not picking up all data. There are three tables. In the unit_measurements each brand and unit_size is unique together as they are in the refuse table. The delivery table can be as many as you like. there is no primary key constraint and i need it that way. the report is only picking up one row from the delivery table, not all as well as the data from the unit_measurements and refuse table. I am not sure why this is. below is the sql query from the query that runs the report. I would be grateful for any feedback on this. Thanks Nic SELECT [Unit_Measurements].[Brand], [Unit_Measurements].[unit_Size], [Brand].[Operator], [Operator].[Operator_contact_name], [Unit_Measurements].[Water_Pipe_Diameter], [Operator].[Operator_contact_no], [Delivery].[Delivery], [Delivery].[Largest_Size], [Delivery].[Type_van], [Delivery].[Product_Types], [Unit_Measurements].[Additional_Information], [Unit_Measurements].[Restaurant_Air_Ventilation-Duct_Size], [Unit_Measurements].[Drainage_pipe_diameter], [Unit_Measurements].[Restaurant_Air_Ventilation-Make_Up], [Unit_Measurements].[Restaurant_Air_Ventilation-Extract], [Unit_Measurements].[Kitchen_Air_Ventilation-Duct_Size], [Unit_Measurements].[Kitchen_Air_Ventilation-Make_Up], [Unit_Measurements].[Kitchen_Air_Ventilation-Extract], [Unit_Measurements].[WC_Ventilation-Duct_Size], [Unit_Measurements].[WC_Ventilation-Make_Up], [Unit_Measurements].[WC_Ventilation-Extract], [Unit_Measurements].[Restaurant_Extraction-Duct_Size], [Unit_Measurements].[Restaurant_Extraction-Make_Up], [Unit_Measurements].[Restaurant_Extraction-Extract], [Unit_Measurements].[Kitchen_Extraction-Duct_Size], [Unit_Measurements].[Kitchen_Extraction-Make_Up], [Unit_Measurements].[Kitchen_Extraction-Extract], [Unit_Measurements].[Drainage-number_pipes], [Unit_Measurements].[Bar], [Unit_Measurements].[water_ Pressure], [Unit_Measurements].[Phase], [Unit_Measurements].[Gas_Requirements], [Unit_Measurements].[Electric_Measurement], [Unit_Measurements].[Gas_Measurement], [Unit_Measurements].[Electrical_Requirements], [Unit_Measurements].[Kitchen_Extraction-Duct_Size2], [Unit_Measurements].[Restaurant_Air_Ventilation-Duct_Size2], [Unit_Measurements].[Kitchen_Air_Ventilation-Duct_Size2], [Unit_Measurements].[WC_Ventilation-Duct_Size2], [Unit_Measurements].[Restaurant_Extraction-Duct_Size2], [Refuse].[Details_Refuse_removal], [Refuse].[Bin_Size], [Refuse].[bins_kept], [Refuse].[refuse_disposed_per_week], [Refuse].[refuse_disposed_on_busiest_day], [Refuse].[waste_disposal_unit], [Refuse].[Recycling_Policy], [Refuse].[waste_Oi], [Refuse].[oil_collected], [Refuse].[grease_traps] FROM Operator, Brand, Delivery, Unit_Measurements, Refuse WHERE [Operator].[Operator]=[Brand].[Operator] And [Unit_Measurements].[Brand]=[Brand].[Brand] And [Refuse].[Brand]=[Unit_Measurements].[Brand] And [Refuse].[unit_Size]=[Unit_Measurements].[unit_Size] And [Delivery].[Brand]=[Unit_Measurements].[Brand] And [Delivery].[unit_Size]=[Unit_Measurements].[unit_Size] And [Refuse].[Brand]=[Brand].[Brand] And [Delivery].[Brand]=[Brand].[Brand] And (([Unit_Measurements].[Brand])=[Forms]![rpt_run_frm]![cmbBrand]) And (([Unit_Measurements].[unit_Size])=[Forms]![rpt_run_frm]![cmbUnitSize]) And (([Operator].[Operator])=[Forms]![rpt_run_frm]![cmbOperator]) And (([Refuse].[Brand])=[Forms]![rpt_run_frm]![cmbBrand]) And (([Refuse].[unit_Size])=[Forms]![rpt_run_frm]![cmbUnitSize]) And (([Delivery].[unit_Size])=[Forms]![rpt_run_frm]![cmbUnitSize]) ORDER BY [Unit_Measurements].[Brand], [Operator].[Operator_contact_name], [Operator].[Operator_contact_no], [Delivery].[Product_Types];