Steve Lang
New member
- Local time
- Today, 12:23
- Joined
- Jan 26, 2007
- Messages
- 6
Hi
I have a product working fine under XP written in VB (access 2003 SP2). Most of the program works fine on Vista business but displaying graphs throws up errors. I think i may have narrowed it down to the SQL in the queries.
I used the simple query wizard as a test, the SQL produced automatically caused an error message saying that the function is not available.
Here is the automated SQL:
SELECT DISTINCTROW Format$([MonthlyHoursInit].[Date], 'mmmm yyyy') AS [Date By Month], Sum(MonthlyHoursInit.DayCapDec) AS [Sum Of DayCapDec]
FROM MonthlyHoursInit
GROUP BY Format$([MonthlyHoursInit].[Date], 'mmmm yyyy'), Year([MonthlyHoursInit].[Date])*12+DatePart('m',[MonthlyHoursInit].[Date])-1;
Any help would be great.
I have a product working fine under XP written in VB (access 2003 SP2). Most of the program works fine on Vista business but displaying graphs throws up errors. I think i may have narrowed it down to the SQL in the queries.
I used the simple query wizard as a test, the SQL produced automatically caused an error message saying that the function is not available.
Here is the automated SQL:
SELECT DISTINCTROW Format$([MonthlyHoursInit].[Date], 'mmmm yyyy') AS [Date By Month], Sum(MonthlyHoursInit.DayCapDec) AS [Sum Of DayCapDec]
FROM MonthlyHoursInit
GROUP BY Format$([MonthlyHoursInit].[Date], 'mmmm yyyy'), Year([MonthlyHoursInit].[Date])*12+DatePart('m',[MonthlyHoursInit].[Date])-1;
Any help would be great.