Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / December 2007

Tip: Looking for answers? Try searching our database.

Query, Change Expression if True

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Bob V - 28 Dec 2007 22:56 GMT
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(tblOwnerInfo.OwnerLastName),'',tblOwnerInfo.OwnerLastName & ' ')
& IIf(IsNull(tblOwnerInfo.OwnerFirstName),'',tblOwnerInfo.OwnerFirstName & '
') AS OwnerName, tblOwnerInfo.OwnerID, tblHorseDetails.Invoicing
FROM tblOwnerInfo, tblHorseDetails
WHERE (((tblOwnerInfo.OwnerID)=[tblHorseDetails].[OwnerID]) AND
((tblHorseDetails.HorseID)=[Forms]![frmInvoice]![cbHorseName].[value]));
Bob V - 28 Dec 2007 23:34 GMT
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(tblOwnerInfo.OwnerLastName),'',tblOwnerInfo.OwnerLastName & ' ')
& IIf(IsNull(tblOwnerInfo.OwnerFirstName),'',tblOwnerInfo.OwnerFirstName & '
') AS OwnerName, tblOwnerInfo.OwnerID, tblHorseDetails.Invoicing
FROM tblOwnerInfo, tblHorseDetails
WHERE (((tblOwnerInfo.OwnerID)=[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(tblOwnerInfo.OwnerLastName),'',tblOwnerInfo.OwnerLastName
& ' ') &
IIf(isnull(tblOwnerInfo.OwnerFirstName),'',tblOwnerInfo.OwnerFirstName & '
') & IIf(isnull(tblOwnerInfo.OwnerTitle),'',tblOwnerInfo.OwnerTitle) AS
Name, Format(OwnerPercent,'0.0%') FROM tblOwnerInfo, tblHorseDetails WHERE
tblOwnerInfo.OwnerID=tblHorseDetails.OwnerID And tblHorseDetails.HorseID=38;

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

> ExceptWhere tblHorseDetails.Invoicing is True (Check Box)
> I am trying to stop this query reconizing any OwnerID, HorseID that is
[quoted text clipped - 9 lines]
> WHERE (((tblOwnerInfo.OwnerID)=[tblHorseDetails].[OwnerID]) AND
> ((tblHorseDetails.HorseID)=[Forms]![frmInvoice]![cbHorseName].[value]));
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.