What is the best way to place two PARAMETERS in a query object?. I tried the one below but did not work. I was getting:
"Syntax error in PARAMETER Clause"
------------
PARAMETERS [BeginDate] DateTime, [EndDate] DateTime
AND PARAMETERS [LastName] & "."' & [FirstName];
SELECT tblW.PermitNo, tblW.PermitIDate, tblW.AppDate, [LastName] & " " & [FirstName] AS CustomerName
FROM tblW INNER JOIN tblCustomer ON tblW.CustomerID = tblCustomer.CustomerID
WHERE (((tblW.GenStatus)="NoPerm
it" Or (tblW.GenStatus)="Applicat
ion"))
GROUP BY tblW.PermitNo, tblW.PermitIDate, tblW.AppDate, [LastName] & " " & [FirstName]
ORDER BY [LastName] & " " & [FirstName];
Start Free Trial
