I want to create a parameter in SQL that will look at my unbound form in access and pull those dates. i am stumped. Can you please help me?
Here is my SQL stored procedure below:
*****FromDate=[Forms]![dlgrptb]![BegDate]
*****ToDate=[Forms]![dlgrptb]![EndDate]
CREATE PROCEDURE dbo.Excel_NB_QRY_VerifyDateInfo2
@FromDate dateTime,
@ToDate datetime
AS
SELECT ISNULL(CONVERT(VARCHAR,f.frstnm + ' ' + f.lstnm),'NONE') as 'TABLES 1',
ISNULL(CONVERT(VARCHAR,g.frstnm + ' ' + g.lstnm),'NONE') as 'TABLES 2',
ISNULL(CONVERT(VARCHAR,D.BlSys),'CHECK ID') AS 'BILL SYS',
ISNULL(CONVERT(VARCHAR,c.Chnl),'CHECK ID') AS 'CHANNEL',
UPPER(LTRIM(RTRIM(b.SIDRqstID))), UPPER(LTRIM(RTRIM(b.SIDRqst))), UPPER(LTRIM(RTRIM(b.Rqstr))),
ISNULL(CONVERT(VARCHAR,b.PrpsdLnch, 101),'NO DATE'),ISNULL(CONVERT(VARCHAR,b.CmfrmdLnch,101),'NO DATE'),
UPPER(e.Stus),ISNULL(CONVERT(VARCHAR,a.[Max Of Actual Launch Date],101),'NO DATE'),
ISNULL(CONVERT(VARCHAR,a.[Max Of RA Validation Date],101),'NO DATE'),
ISNULL(CONVERT(VARCHAR,a.[Max Of Final Bill Code Date],101),'NO DATE'),
ISNULL(CONVERT(VARCHAR,a.[Max Of Pre Bill Code Date],101),'NO DATE'),
ISNULL(CONVERT(VARCHAR,a.[Max Of Feedback Date],101),'NO DATE'),
ISNULL(CONVERT(VARCHAR,b.Fnl,101),'NO DATE'),
ISNULL(CONVERT(VARCHAR,b.Vrsn1,101),'NO DATE')
FROM dbo.QryMaxLaunchDateAll_NEW a
JOIN dbo.SIDMstr b ON a.SIDRqstID = b.[SIDRqstID]
LEFT OUTER JOIN dbo.Chnl c ON b.ChnlID = c.ChnlID
LEFT OUTER JOIN dbo.BlSys d ON B.BSID = D.BSID
LEFT OUTER JOIN dbo.Stus e ON b.StusID = e.StusID
LEFT OUTER JOIN dbo.Drctry f ON b.Tbls1 = f.TMID
LEFT OUTER JOIN dbo.Drctry g ON b.Tbls2 = g.TMID
WHERE b.CmfrmdLnch IS NOT NULL
AND b.CmfrmdLnch Between @FromDate And @ToDate
AND e.StusID=4
ORDER BY b.BSID, a.[Max Of Actual Launch Date]
GO
Here is my SQL stored procedure below:
*****FromDate=[Forms]![dlgrptb]![BegDate]
*****ToDate=[Forms]![dlgrptb]![EndDate]
CREATE PROCEDURE dbo.Excel_NB_QRY_VerifyDateInfo2
@FromDate dateTime,
@ToDate datetime
AS
SELECT ISNULL(CONVERT(VARCHAR,f.frstnm + ' ' + f.lstnm),'NONE') as 'TABLES 1',
ISNULL(CONVERT(VARCHAR,g.frstnm + ' ' + g.lstnm),'NONE') as 'TABLES 2',
ISNULL(CONVERT(VARCHAR,D.BlSys),'CHECK ID') AS 'BILL SYS',
ISNULL(CONVERT(VARCHAR,c.Chnl),'CHECK ID') AS 'CHANNEL',
UPPER(LTRIM(RTRIM(b.SIDRqstID))), UPPER(LTRIM(RTRIM(b.SIDRqst))), UPPER(LTRIM(RTRIM(b.Rqstr))),
ISNULL(CONVERT(VARCHAR,b.PrpsdLnch, 101),'NO DATE'),ISNULL(CONVERT(VARCHAR,b.CmfrmdLnch,101),'NO DATE'),
UPPER(e.Stus),ISNULL(CONVERT(VARCHAR,a.[Max Of Actual Launch Date],101),'NO DATE'),
ISNULL(CONVERT(VARCHAR,a.[Max Of RA Validation Date],101),'NO DATE'),
ISNULL(CONVERT(VARCHAR,a.[Max Of Final Bill Code Date],101),'NO DATE'),
ISNULL(CONVERT(VARCHAR,a.[Max Of Pre Bill Code Date],101),'NO DATE'),
ISNULL(CONVERT(VARCHAR,a.[Max Of Feedback Date],101),'NO DATE'),
ISNULL(CONVERT(VARCHAR,b.Fnl,101),'NO DATE'),
ISNULL(CONVERT(VARCHAR,b.Vrsn1,101),'NO DATE')
FROM dbo.QryMaxLaunchDateAll_NEW a
JOIN dbo.SIDMstr b ON a.SIDRqstID = b.[SIDRqstID]
LEFT OUTER JOIN dbo.Chnl c ON b.ChnlID = c.ChnlID
LEFT OUTER JOIN dbo.BlSys d ON B.BSID = D.BSID
LEFT OUTER JOIN dbo.Stus e ON b.StusID = e.StusID
LEFT OUTER JOIN dbo.Drctry f ON b.Tbls1 = f.TMID
LEFT OUTER JOIN dbo.Drctry g ON b.Tbls2 = g.TMID
WHERE b.CmfrmdLnch IS NOT NULL
AND b.CmfrmdLnch Between @FromDate And @ToDate
AND e.StusID=4
ORDER BY b.BSID, a.[Max Of Actual Launch Date]
GO