UPDATE dbo_tblSaaDocument RIGHT JOIN (dbo_tblObligationType INNER JOIN
(dbo_TblProductVersion INNER JOIN (DEV_dbo_TblProduct RIGHT JOIN
dbo_TblProduct ON DEV_dbo_TblProduct.ProductId = dbo_TblProduct.ProductId)
ON
dbo_TblProductVersion.ProductId = dbo_TblProduct.ProductId) ON
dbo_tblObligationType.ObligationTypeID = dbo_TblProduct.ObligationTypeID)
ON
dbo_tblSaaDocument.SaaDocumentID = dbo_tblObligationType.SaaDocumentID SET
dbo_TblProductVersion.Attachments =
IIf([dbo_tblProductversion].[Attachments]=True,"Y","N"),
DEV_dbo_TblProduct.ProductId = DEV_dbo_TblProduct.ProductId,
dbo_TblProduct.ProductId = DEV_dbo_TblProduct.productid,
dbo_TblProduct.StateAbbr = DEV_dbo_TblProduct.stateabbr,
dbo_TblProductVersion.BondAmtMin = DEV_dbo_TblProduct.BondAmtMin,
dbo_tblObligationType.ProductLine = DEV_dbo_TblProduct.ProductLine,
dbo_TblProductVersion.BondAmtStd = DEV_dbo_TblProduct.BondAmtStd,
dbo_TblProductVersion.BondAmtMax = DEV_dbo_TblProduct.BondAmtMax,
dbo_tblObligationType.BondType = DEV_dbo_TblProduct.BondType,
dbo_TblProductVersion.BondTermMonths = DEV_dbo_TblProduct.BondTermMonths,
dbo_TblProductVersion.CancelDays = DEV_dbo_TblProduct.CancelDays,
dbo_TblProduct.ObligationTypeID = DEV_dbo_TblProduct.ObligationTypeID,
dbo_tblObligationType.CategoryID = DEV_dbo_TblProduct.CategoryID,
dbo_TblProductVersion.BondExpirationDate =
DEV_dbo_TblProduct.BondExpirationDate, dbo_TblProduct.[Available Online] =
DEV_dbo_TblProduct.AvailableOnline, dbo_TblProductVersion.MinCreditScore =
DEV_dbo_TblProduct.MinCreditScore, dbo_TblProductVersion.NewBusinessFormID
=
DEV_dbo_TblProduct.FormId, dbo_TblProductVersion.BondEffectiveDate =
DEV_dbo_TblProduct.BondEffectiveDate, dbo_tblSaaDocument.ClassCode =
DEV_dbo_TblProduct.ClassCode, dbo_TblProductVersion.RiskType =
DEV_dbo_TblProduct.RiskType, dbo_TblProductVersion.RateType =
DEV_dbo_TblProduct.RateType, dbo_TblProductVersion.RenewalMethod =
DEV_dbo_TblProduct.RenewalMethod, dbo_TblProductVersion.RateCode =
DEV_dbo_TblProduct.RateCode, dbo_TblProduct.BondObligationDescription =
DEV_dbo_TblProduct.BondObligationDescription, dbo_TblProduct.ObligeeId =
DEV_dbo_TblProduct.ObligeeID, dbo_TblProductVersion.SpecialInstructions =
DEV_dbo_TblProduct.SpecialInstructions
WHERE (((DEV_dbo_TblProduct.ProductId) Is Not Null)) OR
(((dbo_TblProduct.ProductId)<>[dbo_tblProduct].[ProductId]) AND
((dbo_TblProduct.StateAbbr)<>[dbo_tblProduct].[StateAbbr]) AND
((dbo_TblProductVersion.BondAmtMin)<>[dbo_TblProductVersion].[BondAmtMin]))
OR (((dbo_tblObligationType.ProductLine) Not Like
[dbo_tblObligationType].[ProductLine]) AND
((dbo_TblProductVersion.BondAmtStd)<>[dbo_TblProductVersion].[BondAmtStd])
AND
((dbo_TblProductVersion.BondAmtMax)<>[dbo_TblProductVersion].[BondAmtmax]))
OR (((dbo_tblObligationType.BondType) Not Like
[dbo_tblObligationType].[BondType]) AND
((dbo_TblProductVersion.BondTermMonths)<>[dbo_TblProductVersion].[BondTermMonths])
AND
((dbo_TblProductVersion.CancelDays)<>[dbo_TblProductVersion].[CancelDays])
AND
((dbo_TblProduct.ObligationTypeID)<>[dbo_TblProduct].[ObligationTypeID]))
OR (((dbo_tblObligationType.CategoryID) Not Like
[dbo_tblObligationType].[CategoryID]) AND
((dbo_TblProductVersion.BondExpirationDate)<>[dbo_TblProductVersion].[BondExpirationDate])
AND ((dbo_TblProduct.[Available Online])<>[dbo_TblProduct].[Available
Online]) AND
((dbo_TblProductVersion.MinCreditScore)<>[dbo_TblProductVersion].[MinCreditScore]))
OR
(((dbo_TblProductVersion.NewBusinessFormID)<>[dbo_TblProductVersion].[NewBusinessFormID])
AND
((dbo_TblProductVersion.BondEffectiveDate)<>[dbo_TblProductVersion].[BondEffectiveDate])
AND ((dbo_tblSaaDocument.ClassCode)<>[dbo_tblSaaDocument].[ClassCode]) AND
((dbo_TblProductVersion.RiskType)<>[dbo_TblProductVersion].[RiskType])) OR
(((dbo_TblProductVersion.RateType)<>[dbo_TblProductVersion].[RateType])
AND
((dbo_TblProductVersion.RenewalMethod)<>[dbo_TblProductVersion].[RenewalMethod])
AND ((dbo_TblProductVersion.RateCode)<>[dbo_TblProductVersion].[RateCode])
AND
((dbo_TblProduct.BondObligationDescription)<>[dbo_TblProduct].[BondObligationDescription]))
OR (((dbo_TblProduct.ObligeeId)<>[dbo_TblProduct].[ObligeeId]) AND
((dbo_TblProductVersion.SpecialInstructions)<>[dbo_TblProductVersion].[SpecialInstructions]))
WITH OWNERACCESS OPTION;
Duane Hookom said:
Please post your entire SQL. Your sample doesn't look anything like an
update query.
--
Duane Hookom
MS Access MVP
Attachments: IIf([dbo_tblProductversion].[Attachments]=True,"Y","N")
It works fine in the select query but when I change to my update query
it
say it is not a valid name and to make sure it includes the right () {}
""
etc.
This expression works perfectly in my Append query so why not this one?
My
Update query that I am trying to creat is just a cut and paste of the
Append.
So why does it not work?
PLEASE HELP!