I got a lot of help with a question a few months ago and I'm back again.
I am publishing some reports as data access pages on IIS server for our intranet. When I use a report that is based on a parameter query, I want the user to be able to enter a parameter much as they would do in Access. Instead, I am getting a different parameter box that appears to not pass the parameter through, as it returns no results. Here is the SQL view of the query that one such report is based on.
SELECT Employee.Name AS Employee_Name, Employee.[Current?], Employee.[Full Time?], Employee.[Hire Date], [All Data].[Data Type], Max([All Data].Date) AS MaxOfDate, [All Data].[Record Type]
FROM Employee INNER JOIN [All Data] ON Employee.Name = [All Data].Name
GROUP BY Employee.Name, Employee.[Current?], Employee.[Full Time?], Employee.[Hire Date], [All Data].[Data Type], [All Data].[Record Type], [All Data].Name
HAVING (((Employee.Name) Like "*" & [Please Enter A Name: ] & "*"
)
ORDER BY Employee.Name, [All Data].[Record Type];
I am not familiar with SQL language, so please be fairly explicit with your instructions.
Thanks, Rick
I am publishing some reports as data access pages on IIS server for our intranet. When I use a report that is based on a parameter query, I want the user to be able to enter a parameter much as they would do in Access. Instead, I am getting a different parameter box that appears to not pass the parameter through, as it returns no results. Here is the SQL view of the query that one such report is based on.
SELECT Employee.Name AS Employee_Name, Employee.[Current?], Employee.[Full Time?], Employee.[Hire Date], [All Data].[Data Type], Max([All Data].Date) AS MaxOfDate, [All Data].[Record Type]
FROM Employee INNER JOIN [All Data] ON Employee.Name = [All Data].Name
GROUP BY Employee.Name, Employee.[Current?], Employee.[Full Time?], Employee.[Hire Date], [All Data].[Data Type], [All Data].[Record Type], [All Data].Name
HAVING (((Employee.Name) Like "*" & [Please Enter A Name: ] & "*"
)ORDER BY Employee.Name, [All Data].[Record Type];
I am not familiar with SQL language, so please be fairly explicit with your instructions.
Thanks, Rick
