Today I got a message from one of my bosses that he is unable to obtian/print several reports. The SQL statement below is the underlying statement for all reports.
This report has been available for about 3 days now and I am able to preview/print the report without any problems - as well as others. My system has Access 97 (Windows is 98) but I know execs have Windows XP and have Access 97 installed on their PCs.
SELECT [Employee Data].FirstName, [Employee Data].LastName, tblDailyEntry.[ADP#], [Team Data].TeamName, [Team Data].[TeamID#], CDate(Format((Month([Date])) & "/1/" & Year([Date]),"mm/dd/yy")) AS Month FROM tblDailyEntry INNER JOIN ([Employee Data] INNER JOIN [Team Data] ON [Employee Data].[TeamID#] = [Team Data].[TeamID#]) ON tblDailyEntry.[ADP#] = [Employee Data].[ADPId#] WHERE ((([Employee Data].[Status:Active/Term])="A")) GROUP BY [Employee Data].FirstName, [Employee Data].LastName, tblDailyEntry.[ADP#], [Team Data].TeamName, [Team Data].[TeamID#], CDate(Format((Month([Date])) & "/1/" & Year([Date]),"mm/dd/yy"));
The portion that is returned with the error message is CDate(Format((Month([Date])) & "/1/" & Year([Date]),"mm/dd/yy"))
Any assistance would be greately appreciated...
This report has been available for about 3 days now and I am able to preview/print the report without any problems - as well as others. My system has Access 97 (Windows is 98) but I know execs have Windows XP and have Access 97 installed on their PCs.
SELECT [Employee Data].FirstName, [Employee Data].LastName, tblDailyEntry.[ADP#], [Team Data].TeamName, [Team Data].[TeamID#], CDate(Format((Month([Date])) & "/1/" & Year([Date]),"mm/dd/yy")) AS Month FROM tblDailyEntry INNER JOIN ([Employee Data] INNER JOIN [Team Data] ON [Employee Data].[TeamID#] = [Team Data].[TeamID#]) ON tblDailyEntry.[ADP#] = [Employee Data].[ADPId#] WHERE ((([Employee Data].[Status:Active/Term])="A")) GROUP BY [Employee Data].FirstName, [Employee Data].LastName, tblDailyEntry.[ADP#], [Team Data].TeamName, [Team Data].[TeamID#], CDate(Format((Month([Date])) & "/1/" & Year([Date]),"mm/dd/yy"));
The portion that is returned with the error message is CDate(Format((Month([Date])) & "/1/" & Year([Date]),"mm/dd/yy"))
Any assistance would be greately appreciated...