'Not a Valid Alias Name' Error

  • Thread starter Thread starter Darren Tyler
  • Start date Start date
D

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
 
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];
 
Back
Top