I imported the Access DB into SQL 2005 and ran the query, with no problems.

The lines in bold are the changes I made:


USE sqa

SELECT tblContact.LastName,
tblContact.FirstName,
tblClientSite.SiteName,
tblClientSite.Address1,
tblClientSite.Address2,
tblClientSite.City,
tblClientSite.State,
tblClientSite.ZIP,
tblContact.Phone,
tblContact.Fax,
tblContact.Email,
tblSalesperson.LastName,
tblSalesperson.FirstName,
tblSalesperson.PhoneNumber,
tblSalesperson.Extension,
tblSalesperson.Email,
tblQuote_Original.ContractNumber,
tblQuote_Version.Version,
tblQuote_Version.VersionDate,
tblQuote_Version.UnivDisc,
tblQuote_Version.UnivDesc,
tblQuote_Version.EffectiveDate,
tblQuote_Version.SupportTSA,
tblQuote_Version.PlatformTSA,
tblPlatforms.PlatformTSA,
tblQuote_Version.SeriesTSA,
tblQuote_Version.UsersTSA,
tblQuote_Version.AddProdsTSA,
tblQuote_Version.CostTSA,
tblQuote_Version.SupportRSAESS,
tblQuote_Version.PlatformRSAESS,
tblQuote_Version.SeriesRSAESS,
tblQuote_Version.UsersRSAESS,
tblQuote_Version.AddProdsRSAESS,
tblQuote_Version.HoursPerYear,
tblQuote_Version.CostRSAESS,
tblQuote_Version.CoS,
tblQuote_Version.DistCE
FROM tblClientSite
INNER JOIN (tblContact
INNER JOIN (tblSalesperson
INNER JOIN (tblQuote_Original
INNER JOIN tblQuote_Version
ON tblQuote_Original.PK_ID = tblQuote_Version.FK_Quote_OriginalID)
ON tblSalesperson.PK_ID = tblQuote_Original.FK_Salesperson)
ON tblContact.PK_ID = tblQuote_Original.FK_Contact)
ON (tblClientSite.PK_ID = tblQuote_Original.FK_ClientSite) AND (tblClientSite.PK_ID = tblContact.FK_ClientSite)
JOIN tblPlatforms ON tblPlatforms.pk_id = tblQuote_Version.PlatformTSAKey



In SQL this runs fine and I get data back. In MS Access 2002 I get the error "Invalid syntax near the FROM clause"