System Resource Exceeded!!

[walt]

I am getting error "System Resource Exceeded" error in an Access 2000 database when I execute the following:
SELECT
'131' AS REC_131,
'1' AS LINE_ITM_NBR,
'EA' AS UM_CODE,
'0.00' AS UNIT_PRICE,
'0.00' AS LINE_ITM_AMT_EXTND,
[AQRYPROCESSMASTERSPECIALFORMS].[Labdol] AS LINE_ITM_AMT,
'E' AS PRICE_PER,
[Labor_invnum],
labdtl
FROM AQRYPROCESSMASTERSPECIALFORMS
WHERE [AQRYPROCESSMASTERSPECIALFORMS].[labdtl]='1d'
And [AQRYPROCESSMASTERSPECIALFORMS].[Labdol] Is Not Null
ORDER BY [Labor_invnum],labdtl

UNION

SELECT
'131' AS REC_131,
'1' AS LINE_ITM_NBR,
'EA' AS UM_CODE,
'0.00' AS UNIT_PRICE,
'0.00' AS LINE_ITM_AMT_EXTND,
[AQRYPROCESSMASTERSPECIALFORMS].[Trvdol] AS LINE_ITM_AMT,
'E' AS PRICE_PER,
[Travel_invnum],
Trvdtl AS labdtl
FROM AQRYPROCESSMASTERSPECIALFORMS
WHERE [AQRYPROCESSMASTERSPECIALFORMS].[Trvdtl]='1d'
And [AQRYPROCESSMASTERSPECIALFORMS].[Trvdol] Is Not Null
ORDER BY [Labor_invnum], labdtl

UNION

SELECT
'131' AS REC_131,
'1' AS LINE_ITM_NBR,
'EA' AS UM_CODE,
'0.00' AS UNIT_PRICE,
'0.00' AS LINE_ITM_AMT_EXTND,
[AQRYIWTACALCULATIONS].[MTD_BILLED] AS LINE_ITM_AMT,
'E' AS PRICE_PER,
[AQRYIWTACALCULATIONS].[INVOICE NUMBER],
'1d' AS labdtl
FROM AQRYIWTACALCULATIONS INNER JOIN tblGL2WIP_BY_MASTER ON [AQRYIWTACALCULATIONS].[MAS]=[tblGL2WIP_BY_MASTER].[MASTER]
WHERE not exists (SELECT AQryProcessMasterSpecialForms.MASTER FROM AQryProcessMasterSpecialForms)
ORDER BY [Labor_invnum], labdtl

Union

SELECT
'131' AS REC_131,
'2' AS LINE_ITM_NBR,
'EA' AS UM_CODE,
'0.00' AS UNIT_PRICE,
'0.00' AS LINE_ITM_AMT_EXTND,
[AQRYPROCESSMASTERSPECIALFORMS].[Fridol] AS LINE_ITM_AMT,
'E' AS PRICE_PER,
[labor_invnum],
Fridtl
FROM AQRYPROCESSMASTERSPECIALFORMS
WHERE [AQRYPROCESSMASTERSPECIALFORMS].[Fridtl]='2d'
And [AQRYPROCESSMASTERSPECIALFORMS].[Fridol] Is Not Null
ORDER BY Labor_invnum , labdtl

UNION

SELECT
'131' AS REC_131,
'2' AS LINE_ITM_NBR,
'EA' AS UM_CODE,
'0.00' AS UNIT_PRICE,
'0.00' AS LINE_ITM_AMT_EXTND,
[AQRYPROCESSMASTERSPECIALFORMS].[ovgadol] AS LINE_ITM_AMT,
'E' AS PRICE_PER,
[labor_invnum],
Ovhdtl
FROM AQRYPROCESSMASTERSPECIALFORMS
WHERE [AQRYPROCESSMASTERSPECIALFORMS].[Ovhdtl]='3d'
And [AQRYPROCESSMASTERSPECIALFORMS].[Ovgadol] Is Not Null
ORDER BY Labor_invnum , labdtl

UNION

SELECT
'131' AS REC_131,
'4' AS LINE_ITM_NBR,
'EA' AS UM_CODE,
'0.00' AS UNIT_PRICE,
'0.00' AS LINE_ITM_AMT_EXTND,
([AQRYPROCESSMASTERSPECIALFORMS].[TRVdol]) AS LINE_ITM_AMT,
'E' AS PRICE_PER,
[Labor_invnum],
trvdtl
FROM AQRYPROCESSMASTERSPECIALFORMS
WHERE trvdtl='4d'
And travel_invnum=' '
ORDER BY Labor_invnum, labdtl;

Has anyone else expreience this type of problem?

 

[scking]

This is not really a problem with Access. You have not correctly created the SQL. I assume the your '131', '4' etc are values in a field. You have not identified which field is to be used for the comparison. The example below evaluates each value in the Field1 field of the AQRYIWTACALCULATIONS table and returns whose which contain the textual value of 131.

SELECT Field1 As REC_131 FROM AQRYIWTACALCULATIONS WHERE Field1 = '131';
-------------------------------------
scking@arinc.com
Try to resolve problems independently
Then seek help among peers or experts
But TEST recommended solutions
-------------------------------------