Too many fields defined

J

Jeff Kaufman

I am currently using access 2003 and I am getting a too many fields defined
error when attempting to combine 5 sepereate queries into 1. I have tried
doing the compact and repair and then rebuild the query that is listed as a
suggestion on on other questions and that didn't work. I have listed my SQL
information below.. any help would be great. Thanks


SELECT [Employee Hierarchy - Current Month].[Performance Year], [Employee
Hierarchy - Current Month].[Performance Month], [Employee Hierarchy - Current
Month].ATTUID, [Employee Hierarchy - Current Month].Skill, [Employee
Hierarchy - Current Month].Ramp, [TC-All-Weeks].[TC-Week1-Step2].[Trans and
Conf], [TC-All-Weeks].[TC-Week1-Step2].SCPTS,
[TC-All-Weeks].[TC-Week2-Step2].[Trans and Conf],
[TC-All-Weeks].[TC-Week2-Step2].SCPTS, [TC-All-Weeks].[TC-Week3-Step2].[Trans
and Conf], [TC-All-Weeks].[TC-Week3-Step2].SCPTS,
[TC-All-Weeks].[TC-Week4-Step2].[Trans and Conf],
[TC-All-Weeks].[TC-Week4-Step2].SCPTS, [TC-All-Weeks].[TC-Week5-Step2].[Trans
and Conf], [TC-All-Weeks].[TC-Week5-Step2].SCPTS,
[SC-All-Weeks].[SC-Week1-Step2].[Short Calls],
[SC-All-Weeks].[SC-Week1-Step2].SCPTS, [SC-All-Weeks].[SC-Week2-Step2].[Short
Calls], [SC-All-Weeks].[SC-Week2-Step2].SCPTS,
[SC-All-Weeks].[SC-Week3-Step2].[Short Calls],
[SC-All-Weeks].[SC-Week3-Step2].SCPTS, [SC-All-Weeks].[SC-Week4-Step2].[Short
Calls], [SC-All-Weeks].[SC-Week4-Step2].SCPTS,
[SC-All-Weeks].[SC-Week5-Step2].[Short Calls],
[SC-All-Weeks].[SC-Week5-Step2].SCPTS,
[SI-All-Weeks].[SI-Week1-Step2].[Signed-In],
[SI-All-Weeks].[SI-Week1-Step2].SCPTS,
[SI-All-Weeks].[SI-Week2-Step2].[Signed-In],
[SI-All-Weeks].[SI-Week2-Step2].SCPTS,
[SI-All-Weeks].[SI-Week3-Step2].[Signed-In],
[SI-All-Weeks].[SI-Week3-Step2].SCPTS,
[SI-All-Weeks].[SI-Week4-Step2].[Signed-In],
[SI-All-Weeks].[SI-Week4-Step2].SCPTS,
[SI-All-Weeks].[SI-Week5-Step2].[Signed-In],
[SI-All-Weeks].[SI-Week5-Step2].SCPTS, [QA-All-Weeks].[QA-Week1-Step2].QA,
[QA-All-Weeks].[QA-Week1-Step2].SCPTS, [QA-All-Weeks].[QA-Week2-Step2].QA,
[QA-All-Weeks].[QA-Week2-Step2].SCPTS, [QA-All-Weeks].[QA-Week3-Step2].QA,
[QA-All-Weeks].[QA-Week3-Step2].SCPTS, [QA-All-Weeks].[QA-Week4-Step2].QA,
[QA-All-Weeks].[QA-Week4-Step2].SCPTS, [QA-All-Weeks].[QA-Week5-Step2].QA,
[QA-All-Weeks].[QA-Week5-Step2].SCPTS
FROM ((([Employee Hierarchy - Current Month] LEFT JOIN [TC-All-Weeks] ON
([Employee Hierarchy - Current Month].ATTUID = [TC-All-Weeks].ATTUID) AND
([Employee Hierarchy - Current Month].[Performance Month] =
[TC-All-Weeks].[Performance Month]) AND ([Employee Hierarchy - Current
Month].[Performance Year] = [TC-All-Weeks].[Performance Year])) LEFT JOIN
[SC-All-Weeks] ON ([Employee Hierarchy - Current Month].ATTUID =
[SC-All-Weeks].ATTUID) AND ([Employee Hierarchy - Current Month].[Performance
Month] = [SC-All-Weeks].[Performance Month]) AND ([Employee Hierarchy -
Current Month].[Performance Year] = [SC-All-Weeks].[Performance Year])) LEFT
JOIN [SI-All-Weeks] ON ([Employee Hierarchy - Current Month].ATTUID =
[SI-All-Weeks].ATTUID) AND ([Employee Hierarchy - Current Month].[Performance
Month] = [SI-All-Weeks].[Performance Month]) AND ([Employee Hierarchy -
Current Month].[Performance Year] = [SI-All-Weeks].[Performance Year])) LEFT
JOIN [QA-All-Weeks] ON ([Employee Hierarchy - Current Month].ATTUID =
[QA-All-Weeks].ATTUID) AND ([Employee Hierarchy - Current Month].[Performance
Month] = [QA-All-Weeks].[Performance Month]) AND ([Employee Hierarchy -
Current Month].[Performance Year] = [QA-All-Weeks].[Performance Year]);
 
A

Arvin Meyer [MVP]

Try using a Union Query.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


Jeff Kaufman said:
I am currently using access 2003 and I am getting a too many fields defined
error when attempting to combine 5 sepereate queries into 1. I have tried
doing the compact and repair and then rebuild the query that is listed as
a
suggestion on on other questions and that didn't work. I have listed my
SQL
information below.. any help would be great. Thanks


SELECT [Employee Hierarchy - Current Month].[Performance Year], [Employee
Hierarchy - Current Month].[Performance Month], [Employee Hierarchy -
Current
Month].ATTUID, [Employee Hierarchy - Current Month].Skill, [Employee
Hierarchy - Current Month].Ramp, [TC-All-Weeks].[TC-Week1-Step2].[Trans
and
Conf], [TC-All-Weeks].[TC-Week1-Step2].SCPTS,
[TC-All-Weeks].[TC-Week2-Step2].[Trans and Conf],
[TC-All-Weeks].[TC-Week2-Step2].SCPTS,
[TC-All-Weeks].[TC-Week3-Step2].[Trans
and Conf], [TC-All-Weeks].[TC-Week3-Step2].SCPTS,
[TC-All-Weeks].[TC-Week4-Step2].[Trans and Conf],
[TC-All-Weeks].[TC-Week4-Step2].SCPTS,
[TC-All-Weeks].[TC-Week5-Step2].[Trans
and Conf], [TC-All-Weeks].[TC-Week5-Step2].SCPTS,
[SC-All-Weeks].[SC-Week1-Step2].[Short Calls],
[SC-All-Weeks].[SC-Week1-Step2].SCPTS,
[SC-All-Weeks].[SC-Week2-Step2].[Short
Calls], [SC-All-Weeks].[SC-Week2-Step2].SCPTS,
[SC-All-Weeks].[SC-Week3-Step2].[Short Calls],
[SC-All-Weeks].[SC-Week3-Step2].SCPTS,
[SC-All-Weeks].[SC-Week4-Step2].[Short
Calls], [SC-All-Weeks].[SC-Week4-Step2].SCPTS,
[SC-All-Weeks].[SC-Week5-Step2].[Short Calls],
[SC-All-Weeks].[SC-Week5-Step2].SCPTS,
[SI-All-Weeks].[SI-Week1-Step2].[Signed-In],
[SI-All-Weeks].[SI-Week1-Step2].SCPTS,
[SI-All-Weeks].[SI-Week2-Step2].[Signed-In],
[SI-All-Weeks].[SI-Week2-Step2].SCPTS,
[SI-All-Weeks].[SI-Week3-Step2].[Signed-In],
[SI-All-Weeks].[SI-Week3-Step2].SCPTS,
[SI-All-Weeks].[SI-Week4-Step2].[Signed-In],
[SI-All-Weeks].[SI-Week4-Step2].SCPTS,
[SI-All-Weeks].[SI-Week5-Step2].[Signed-In],
[SI-All-Weeks].[SI-Week5-Step2].SCPTS, [QA-All-Weeks].[QA-Week1-Step2].QA,
[QA-All-Weeks].[QA-Week1-Step2].SCPTS, [QA-All-Weeks].[QA-Week2-Step2].QA,
[QA-All-Weeks].[QA-Week2-Step2].SCPTS, [QA-All-Weeks].[QA-Week3-Step2].QA,
[QA-All-Weeks].[QA-Week3-Step2].SCPTS, [QA-All-Weeks].[QA-Week4-Step2].QA,
[QA-All-Weeks].[QA-Week4-Step2].SCPTS, [QA-All-Weeks].[QA-Week5-Step2].QA,
[QA-All-Weeks].[QA-Week5-Step2].SCPTS
FROM ((([Employee Hierarchy - Current Month] LEFT JOIN [TC-All-Weeks] ON
([Employee Hierarchy - Current Month].ATTUID = [TC-All-Weeks].ATTUID) AND
([Employee Hierarchy - Current Month].[Performance Month] =
[TC-All-Weeks].[Performance Month]) AND ([Employee Hierarchy - Current
Month].[Performance Year] = [TC-All-Weeks].[Performance Year])) LEFT JOIN
[SC-All-Weeks] ON ([Employee Hierarchy - Current Month].ATTUID =
[SC-All-Weeks].ATTUID) AND ([Employee Hierarchy - Current
Month].[Performance
Month] = [SC-All-Weeks].[Performance Month]) AND ([Employee Hierarchy -
Current Month].[Performance Year] = [SC-All-Weeks].[Performance Year]))
LEFT
JOIN [SI-All-Weeks] ON ([Employee Hierarchy - Current Month].ATTUID =
[SI-All-Weeks].ATTUID) AND ([Employee Hierarchy - Current
Month].[Performance
Month] = [SI-All-Weeks].[Performance Month]) AND ([Employee Hierarchy -
Current Month].[Performance Year] = [SI-All-Weeks].[Performance Year]))
LEFT
JOIN [QA-All-Weeks] ON ([Employee Hierarchy - Current Month].ATTUID =
[QA-All-Weeks].ATTUID) AND ([Employee Hierarchy - Current
Month].[Performance
Month] = [QA-All-Weeks].[Performance Month]) AND ([Employee Hierarchy -
Current Month].[Performance Year] = [QA-All-Weeks].[Performance Year]);
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

To many fields defined error message 0
Tie a Calendar week to a Scoped Projected Week 3
How do i view all my project in a year 1
weekly totals 12
Creating a Dynamic Function 1
Outlook crashes with Outlook connector 2002 0
Outlook connector crashes outlook 0

Top