Hilfe mit Access Queries und Form erstellen

[Mackhack]

Jetzt bitte nicht schlagen fuer so viel...

Delphi-Quellcode:

SELECT [Maintenance Descriptions].[Maintenance Type ID], [Maintenance Descriptions].[Level Code], [Maintenance Descriptions].Description, [Maintenance Descriptions].[Average Hours Required], [Maintenance Descriptions].[Days Between Recommended Maintenance], [Maintenance Descriptions].[Maximum Days Between Maintenance], [Maintenance Work Order].[Work Order ID], [Maintenance Work Order].Vehicle, [Maintenance Work Order].[Part ID], [Maintenance Work Order].[Maintenance Type ID], [Maintenance Work Order].[Assignment TO], [Maintenance Work Order].[Date Started], [Maintenance Work Order].[Date Completed], [Maintenance Work Order].Hours, [Maintenance Work Order].VIN, [Parts Catalogue].ID, [Parts Catalogue].Description, [Parts Catalogue].Type, [Parts Catalogue].Manufacturer, [Parts Catalogue].[Quantity On Hand], [Parts Catalogue].[Reorder Point], [Parts Catalogue].[Reorder Quantity], [Parts Inventory Issues].[Transaction ID], [Parts Inventory Issues].[Purchase Date], [Parts Inventory Issues].[Issue Date], [Parts Inventory Issues].[Purchase Price], [Parts Inventory Issues].Quantity, [Parts Inventory Purchases].[Transaction ID], [Parts Inventory Purchases].[Purchase Date], [Parts Inventory Purchases].[Purchase Price], [Parts Inventory Purchases].Quantity, [Parts Purchasing History].[Transaction ID], [Parts Purchasing History].[Catalogue ID], [Parts Purchasing History].[Quantity Purchased], [Parts Purchasing History].[Manufacturer ID], [Parts Purchasing History].[Order Quantity], [Parts Purchasing History].Price, [Parts Purchasing History].Shipping, [Parts Purchasing History].Tax, [Parts Purchasing History].FOB, [Tire Maintenance].Barcode, [Tire Maintenance].[Manufacturer ID], [Tire Maintenance].[Put in Service Date], [Tire Maintenance].[Rotation Schedule], [Tire Maintenance].[Last Rotated], [Tire Maintenance].[Disposal Date], [Vehicle Maintenance].[Maintenance ID], [Vehicle Maintenance].[Vehicle Serial Number], [Vehicle Maintenance].[Put in Service Date], [Vehicle Maintenance].[Last Maintenance Date], [Vehicle Maintenance].[Next Scheduled Maintenance Date], [Vehicle Maintenance].[Under Warranty Flag], [Vehicle Types].TypeID, [Vehicle Types].Description, Vehicles.VIN, Vehicles.[Type ID], Vehicles.[Class Code], Vehicles.[Put Into Service Date], Vehicles.[Gross Weight], Vehicles.Mileage, Vehicles.[Purchase Price], Vehicles.[Accumulated Depreciation], Vehicles.[Taken Out of Sevice Date], Vehicles.Capacity, Vendors.[Vendor ID], Vendors.Name, Vendors.[Order Adress], Vendors.[Order Contact], Vendors.[Order Phone Number], Vendors.[Order Fax Number], Vendors.[Billing Adress], Vendors.[Billing Contact], Vendors.[Billing Phone Number], Vendors.[Billing Fax Number]
FROM (Vendors INNER JOIN [Parts Catalogue] ON Vendors.[Vendor ID] = [Parts Catalogue].ID) INNER JOIN (([Vehicle Types] INNER JOIN (((([Maintenance Descriptions] INNER JOIN [Maintenance Work Order] ON [Maintenance Descriptions].[Maintenance Type ID] = [Maintenance Work Order].[Maintenance Type ID]) INNER JOIN [Tire Maintenance] ON [Maintenance Descriptions].[Maintenance Type ID] = [Tire Maintenance].Barcode) INNER JOIN Vehicles ON [Maintenance Work Order].[Work Order ID] = Vehicles.VIN) INNER JOIN (([Parts Inventory Issues] INNER JOIN [Parts Purchasing History] ON [Parts Inventory Issues].[Transaction ID] = [Parts Purchasing History].[Transaction ID]) INNER JOIN [Parts Inventory Purchases] ON ([Parts Purchasing History].[Transaction ID] = [Parts Inventory Purchases].[Transaction ID]) AND ([Parts Inventory Issues].[Transaction ID] = [Parts Inventory Purchases].[Transaction ID])) ON [Tire Maintenance].Barcode = [Parts Purchasing History].[Catalogue ID]) ON [Vehicle Types].TypeID = Vehicles.[Type ID]) RIGHT JOIN [Vehicle Maintenance] ON Vehicles.VIN = [Vehicle Maintenance].[Vehicle Serial Number]) ON Vendors.[Vendor ID] = [Parts Purchasing History].[Transaction ID];