AGB  ·  Datenschutz  ·  Impressum  







Anmelden
Nützliche Links
Registrieren
Zurück Delphi-PRAXiS Programmierung allgemein Datenbanken Hilfe mit Access Queries und Form erstellen
Thema durchsuchen
Ansicht
Themen-Optionen

Hilfe mit Access Queries und Form erstellen

Ein Thema von Mackhack · begonnen am 27. Apr 2007 · letzter Beitrag vom 28. Apr 2007
 
Benutzerbild von Mackhack
Mackhack

Registriert seit: 29. Nov 2003
Ort: San Diego, CA/USA
1.446 Beiträge
 
Delphi 2006 Architect
 
#4

Re: Hilfe mit Access Queries und Form erstellen

  Alt 28. Apr 2007, 02:55
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];
Um etwas Neues zu schaffen muss man seine Ohren vor den Nein-sagern verschliessen um seinen Geist öffnen zu können.
(George Lukas)
  Mit Zitat antworten Zitat
 


Forumregeln

Es ist dir nicht erlaubt, neue Themen zu verfassen.
Es ist dir nicht erlaubt, auf Beiträge zu antworten.
Es ist dir nicht erlaubt, Anhänge hochzuladen.
Es ist dir nicht erlaubt, deine Beiträge zu bearbeiten.

BB-Code ist an.
Smileys sind an.
[IMG] Code ist an.
HTML-Code ist aus.
Trackbacks are an
Pingbacks are an
Refbacks are aus

Gehe zu:

Impressum · AGB · Datenschutz · Nach oben
Alle Zeitangaben in WEZ +1. Es ist jetzt 23:46 Uhr.
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
LinkBacks Enabled by vBSEO © 2011, Crawlability, Inc.
Delphi-PRAXiS (c) 2002 - 2023 by Daniel R. Wolf, 2024-2025 by Thomas Breitkreuz