Query, Change Expression if True

[Bob V]

ExceptWhere tblHorseDetails.Invoicing is True (Check Box)
I am trying to stop this query reconizing any OwnerID, HorseID that is True
Thanks for any Help..........Bob

SELECT Format(tblHorseDetails.OwnerPercent,"0.0%") AS Expr1,
IIf(IsNull(tblOwnerInfwnerLastName),'',tblOwnerInfwnerLastName & ' ')
& IIf(IsNull(tblOwnerInfwnerFirstName),'',tblOwnerInfwnerFirstName & '
') AS OwnerName, tblOwnerInfwnerID, tblHorseDetails.Invoicing
FROM tblOwnerInfo, tblHorseDetails
WHERE (((tblOwnerInfwnerID)=[tblHorseDetails].[OwnerID]) AND
((tblHorseDetails.HorseID)=[Forms]![frmInvoice]![cbHorseName].[value]));

 

[Bob V]

I managed to Change this Query so as if True The Owner/HorseID wont show:

SELECT Format(tblHorseDetails.OwnerPercent,"0.0%") AS Expr1,
IIf(IsNull(tblOwnerInfwnerLastName),'',tblOwnerInfwnerLastName & ' ')
& IIf(IsNull(tblOwnerInfwnerFirstName),'',tblOwnerInfwnerFirstName & '
') AS OwnerName, tblOwnerInfwnerID, tblHorseDetails.Invoicing
FROM tblOwnerInfo, tblHorseDetails
WHERE (((tblOwnerInfwnerID)=[tblHorseDetails].[OwnerID]) AND
((tblHorseDetails.Invoicing)=No) AND
((tblHorseDetails.HorseID)=[Forms]![frmInvoice]![cbHorseName].[value]));

BUT how would I change this Row souce to achieve the same result??

SELECT IIf(isnull(tblOwnerInfwnerLastName),'',tblOwnerInfwnerLastName
& ' ') &
IIf(isnull(tblOwnerInfwnerFirstName),'',tblOwnerInfwnerFirstName & '
') & IIf(isnull(tblOwnerInfwnerTitle),'',tblOwnerInfwnerTitle) AS
Name, Format(OwnerPercent,'0.0%') FROM tblOwnerInfo, tblHorseDetails WHERE
tblOwnerInfwnerID=tblHorseDetails.OwnerID And tblHorseDetails.HorseID=38;

Thanks for anyone that can help me.................Bob