'Not a Valid Alias Name' Error

[Darren Tyler]

Help,

I have an Access dbase that I built in Access 2000. I am
attempting to operate it on a computer with Access 2002.
When I attempt to run a particular report, I get 'Not a
Valid Alias Name' error. Several queries build this
report, and I have narrowed it down to the particular
query that gives this error. I have chopped it up several
ways, and cannot figure out the error. It runs fine on my
Access 2000 version, but I need it to work on the 2002
version. I have several other queries for imports and
forms for this dbase, but none of those give me this error.

Any help would be greatly appreciated,
Darren

 

[Jake]

Can you post the SQL string of the query?

Jake

 

[Darren Tyler]

SELECT [Productivity Data Report 70 - Determine
Productivity Standards].[Task Date], [Productivity Data
Report 70 - Determine Productivity Standards].[Shift
Code], [Productivity Data Report 70 - Determine
Productivity Standards].[Activity Type], [Productivity
Data Report 70 - Determine Productivity Standards].
[Activity Type Description], [Productivity Data Report 70 -
Determine Productivity Standards].[Employee Name], Sum
([Productivity Data Report 70 - Determine Productivity
Standards].[Adj Prod Perc]) AS [SumOfAdj Prod Perc]
FROM [Productivity Data Report 70 - Determine Productivity
Standards]
GROUP BY [Productivity Data Report 70 - Determine
Productivity Standards].[Task Date], [Productivity Data
Report 70 - Determine Productivity Standards].[Shift
Code], [Productivity Data Report 70 - Determine
Productivity Standards].[Activity Type], [Productivity
Data Report 70 - Determine Productivity Standards].
[Activity Type Description], [Productivity Data Report 70 -
Determine Productivity Standards].[Employee Name];