Hi all, I have the following query which isn't quite finished!
1) How do i specify the '@Country' parameter is optional in an ACCESS stored
query? (like MSSQL @Country INT = NULL)
2) What is the Access Equivalent of the following AND CLAUSE ?
c.Country = Coalesce(@Country, c.Country)
Query involved below:
c.ID, c.Company_Name, p.[level], 1 As QueryNbr
(Company AS c LEFT JOIN Sale AS s ON c.ID = s.Company_ID)
Package AS p
s.Package_ID = p.ID
c.Category = 'EXH'
(s.ID = (SELECT Max(ID) FROM Sale WHERE Company_ID = c.ID) Or IsNull(s.ID)
EXISTS(SELECT Company_ID FROM Event_Company_Link WHERE Event_ID =
@EventID AND Company_ID = c.ID)
EXISTS(SELECT Company_ID FROM Company_Product_Link WHERE Product_ID =
@Products AND Company_ID = c.ID)
(Start_Date <= Date()+1) AND (End_Date >= Date()+1)
c.Country = /* Need Access equivalent of Coalesce(@Country, c.Country) */
|All times are GMT. The time now is 04:53 AM.|
Powered by vBulletin®. Copyright ©2000 - 2014, vBulletin Solutions, Inc.
SEO by vBSEO ©2010, Crawlability, Inc.