[AccessD] Help with a query

Make your inner joins into outer joins and see what happens.

John W. Colby
www.ColbyConsulting.com 

Contribute your unused CPU cycles to a good cause:
http://folding.stanford.edu/

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Joe Hecht
Sent: Monday, June 06, 2005 10:41 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Help with a query


You are right

SELECT DISTINCTROW PurchaseOrders.PurchaseOrderID, Vendors.VendorName,
Vendors.Address, Vendors.City, Vendors.State, Vendors.Zip, Vendors.Phone,
Vendors.Fax, PurchaseOrders.DateOrdered, PurchaseOrders.DateRequired,
PurchaseOrders.ShippingMethodID, Locations.LocationName,
Locations.LocationAddress, Locations.LocationCity, Locations.LocationState,
Locations.LocationZip, Locations.LocationPhone, Locations.LocationFax,
[City] & " " & [State] & " " & [Zip] AS VendaddLine3, [LocationCity] & " " &
[LocationState] & " " & [LocationZip] AS LocationAddLine3, [Shipping
Methods].ShippingMethod, PurchaseOrders.Notes, PurchaseOrders.Initails,
Locations.LocationID, Department.Department FROM Department INNER JOIN
(Locations INNER JOIN ([Shipping Methods] INNER JOIN (Vendors INNER JOIN
PurchaseOrders ON Vendors.VendorID =
PurchaseOrders.VendorID) ON [Shipping Methods].ShippingMethodID =
PurchaseOrders.ShippingMethodID) ON Locations.LocationID =
PurchaseOrders.LocationID) ON Department.DeptID = PurchaseOrders.DeptID
WHERE
(((PurchaseOrders.PurchaseOrderID)=[Forms]![PurchaseOrders]![PurchaseOrderID
]));

Joe Hecht
Los Angeles CA

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Roz Clarke
Sent: Monday, June 06, 2005 7:34 AM
To: access at joe2.endjunk.com; 'Access Developers discussion and problem
solving'
Subject: RE: [AccessD] Help with a query

your SQL would be helpful Joe

-----Original Message-----
From: Joe Hecht [mailto:jmhecht at earthlink.net] 
Sent: 06 June 2005 15:15
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Help with a query


I have a database where a query works with about 14 of almost 5000 records.
 
I rewrote the query and still the same results
 
I have added data in some fields that were missing data.
 
Ant thoughts
 
TIA
 
Joe Hecht
Los Angeles CA
 
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com