OPENING QUERY Causes error "System Resource Exceeded"

  • Thread starter Thread starter BlueWolverine
  • Start date Start date
B

BlueWolverine

Hello,
Running MS Access 2003 on XP Pro.

I have discovered a very potential root cause for my most recent posting,
about Run Time Error 3035.

I have a query that causes an error msg that says "System Resources Exceeded".

It has never done that before. While I have added data to what this query
would pull, I didn't think I'd added that much, if really anything at all.


Here is the query that dies: (followed by the query it pulls from)

SELECT "Monday" AS DayOfWeek, q_FA.Fleet_Activity, q_FA.BinstoOther,
q_FA.[CCC's], q_FA.VFG, q_FA.VRT, q_FA.[GQRS CAT], q_FA.ACTION, q_FA.[Work
Element Description], q_FA.Frequency, q_FA.[WES#], q_FA.Source, q_FA.ID,
q_FA.Active
FROM q_FA
WHERE [MondayTF]=True
union all
SELECT "Tuesday" AS DayOfWeek, q_FA.Fleet_Activity, q_FA.BinstoOther,
q_FA.[CCC's], q_FA.VFG, q_FA.VRT, q_FA.[GQRS CAT], q_FA.ACTION, q_FA.[Work
Element Description], q_FA.Frequency, q_FA.[WES#], q_FA.Source, q_FA.ID,
q_FA.Active
FROM q_FA
WHERE [TuesdayTF]=True
union all
SELECT "Wednesday" AS DayOfWeek, q_FA.Fleet_Activity, q_FA.BinstoOther,
q_FA.[CCC's], q_FA.VFG, q_FA.VRT, q_FA.[GQRS CAT], q_FA.ACTION, q_FA.[Work
Element Description], q_FA.Frequency, q_FA.[WES#], q_FA.Source, q_FA.ID,
q_FA.Active
FROM q_FA
WHERE [WednesdayTF]=True
union all
SELECT "Thursday" AS DayOfWeek, q_FA.Fleet_Activity, q_FA.BinstoOther,
q_FA.[CCC's], q_FA.VFG, q_FA.VRT, q_FA.[GQRS CAT], q_FA.ACTION, q_FA.[Work
Element Description], q_FA.Frequency, q_FA.[WES#], q_FA.Source, q_FA.ID,
q_FA.Active
FROM q_FA
WHERE [ThursdayTF]=True
union all
SELECT "Friday" AS DayOfWeek, q_FA.Fleet_Activity, q_FA.BinstoOther,
q_FA.[CCC's], q_FA.VFG, q_FA.VRT, q_FA.[GQRS CAT], q_FA.ACTION, q_FA.[Work
Element Description], q_FA.Frequency, q_FA.[WES#], q_FA.Source, q_FA.ID,
q_FA.Active
FROM q_FA
WHERE [FridayTF]=True
union all
SELECT "Saturday" AS DayOfWeek, q_FA.Fleet_Activity, q_FA.BinstoOther,
q_FA.[CCC's], q_FA.VFG, q_FA.VRT, q_FA.[GQRS CAT], q_FA.ACTION, q_FA.[Work
Element Description], q_FA.Frequency, q_FA.[WES#], q_FA.Source, q_FA.ID,
q_FA.Active
FROM q_FA
WHERE [SaturdayTF]=True
UNION ALL SELECT "Sunday" AS DayOfWeek, q_FA.Fleet_Activity,
q_FA.BinstoOther, q_FA.[CCC's], q_FA.VFG, q_FA.VRT, q_FA.[GQRS CAT],
q_FA.ACTION, q_FA.[Work Element Description], q_FA.Frequency, q_FA.[WES#],
q_FA.Source, q_FA.ID, q_FA.Active
FROM q_FA
WHERE [SundayTF]=True
UNION ALL SELECT "Removed" AS DayOfWeek, q_FA.Fleet_Activity,
q_FA.BinstoOther, q_FA.[CCC's], q_FA.VFG, q_FA.VRT, q_FA.[GQRS CAT],
q_FA.ACTION, q_FA.[Work Element Description], q_FA.Frequency, q_FA.[WES#],
q_FA.Source, q_FA.ID, q_FA.Active
FROM q_FA
WHERE [Active]=False
UNION ALL SELECT "N/A" AS DayOfWeek, q_FA.Fleet_Activity, q_FA.BinstoOther,
q_FA.[CCC's], q_FA.VFG, q_FA.VRT, q_FA.[GQRS CAT], q_FA.ACTION, q_FA.[Work
Element Description], q_FA.Frequency, q_FA.[WES#], q_FA.Source, q_FA.ID,
q_FA.Active
FROM q_FA
WHERE ([SundayTF]=False AND [SaturdayTF]=False AND [MondayTF]=False AND
[TuesdayTF]=False AND [WednesdayTF]=False AND [ThursdayTF]=False AND
[FridayTF]=False);


<<Q_FA>>
SELECT "Duty Cycle" as Fleet_Activity, [QMC MASTER LIST].BinstoOther, [QMC
MASTER LIST].[CCC's], [QMC MASTER LIST].VFG, [QMC MASTER LIST].VRT, [QMC
MASTER LIST].[GQRS CAT], [QMC MASTER LIST].ACTION, [QMC MASTER LIST].[Work
Element Description], [QMC MASTER LIST].Frequency, [QMC MASTER LIST].[WES#],
[QMC MASTER LIST].Source, [QMC MASTER LIST].MondayTF, [QMC MASTER
LIST].TuesdayTF, [QMC MASTER LIST].WednesdayTF, [QMC MASTER LIST].ThursdayTF,
[QMC MASTER LIST].FridayTf, [QMC MASTER LIST].SaturdayTF, [QMC MASTER
LIST].SundayTF, [QMC MASTER LIST].CriticalIssueTF, [QMC MASTER LIST].ID,
[QMC MASTER LIST].Active, [QMC MASTER LIST].[CamoTesting]
FROM [QMC MASTER LIST] where [DutyCycleTF]=True
union all
SELECT "Shakedown" as Fleet_Activity, [QMC MASTER LIST].BinstoOther, [QMC
MASTER LIST].[CCC's], [QMC MASTER LIST].VFG, [QMC MASTER LIST].VRT, [QMC
MASTER LIST].[GQRS CAT], [QMC MASTER LIST].ACTION, [QMC MASTER LIST].[Work
Element Description], [QMC MASTER LIST].Frequency, [QMC MASTER LIST].[WES#],
[QMC MASTER LIST].Source, [QMC MASTER LIST].MondayTF, [QMC MASTER
LIST].TuesdayTF, [QMC MASTER LIST].WednesdayTF, [QMC MASTER LIST].ThursdayTF,
[QMC MASTER LIST].FridayTf, [QMC MASTER LIST].SaturdayTF, [QMC MASTER
LIST].SundayTF, [QMC MASTER LIST].CriticalIssueTF, [QMC MASTER LIST].ID,
[QMC MASTER LIST].Active, [QMC MASTER LIST].[CamoTesting]
FROM [QMC MASTER LIST] where [ShakedownTF]=True
UNION ALL SELECT "Extended" as Fleet_Activity, [QMC MASTER
LIST].BinstoOther, [QMC MASTER LIST].[CCC's], [QMC MASTER LIST].VFG, [QMC
MASTER LIST].VRT, [QMC MASTER LIST].[GQRS CAT], [QMC MASTER LIST].ACTION,
[QMC MASTER LIST].[Work Element Description], [QMC MASTER LIST].Frequency,
[QMC MASTER LIST].[WES#], [QMC MASTER LIST].Source, [QMC MASTER
LIST].MondayTF, [QMC MASTER LIST].TuesdayTF, [QMC MASTER LIST].WednesdayTF,
[QMC MASTER LIST].ThursdayTF, [QMC MASTER LIST].FridayTf, [QMC MASTER
LIST].SaturdayTF, [QMC MASTER LIST].SundayTF, [QMC MASTER
LIST].CriticalIssueTF, [QMC MASTER LIST].ID, [QMC MASTER LIST].Active, [QMC
MASTER LIST].[CamoTesting]
FROM [QMC MASTER LIST] where [ExtendedTF]=True
union all
SELECT "EXT - Hot & Humid" as Fleet_Activity, [QMC MASTER LIST].BinstoOther,
[QMC MASTER LIST].[CCC's], [QMC MASTER LIST].VFG, [QMC MASTER LIST].VRT, [QMC
MASTER LIST].[GQRS CAT], [QMC MASTER LIST].ACTION, [QMC MASTER LIST].[Work
Element Description], [QMC MASTER LIST].Frequency, [QMC MASTER LIST].[WES#],
[QMC MASTER LIST].Source, [QMC MASTER LIST].MondayTF, [QMC MASTER
LIST].TuesdayTF, [QMC MASTER LIST].WednesdayTF, [QMC MASTER LIST].ThursdayTF,
[QMC MASTER LIST].FridayTf, [QMC MASTER LIST].SaturdayTF, [QMC MASTER
LIST].SundayTF, [QMC MASTER LIST].CriticalIssueTF, [QMC MASTER LIST].ID,
[QMC MASTER LIST].Active, [QMC MASTER LIST].[CamoTesting]
FROM [QMC MASTER LIST] where [HotHumidTF]=True
union all
SELECT "EXT - Mountains" as Fleet_Activity, [QMC MASTER LIST].BinstoOther,
[QMC MASTER LIST].[CCC's], [QMC MASTER LIST].VFG, [QMC MASTER LIST].VRT, [QMC
MASTER LIST].[GQRS CAT], [QMC MASTER LIST].ACTION, [QMC MASTER LIST].[Work
Element Description], [QMC MASTER LIST].Frequency, [QMC MASTER LIST].[WES#],
[QMC MASTER LIST].Source, [QMC MASTER LIST].MondayTF, [QMC MASTER
LIST].TuesdayTF, [QMC MASTER LIST].WednesdayTF, [QMC MASTER LIST].ThursdayTF,
[QMC MASTER LIST].FridayTf, [QMC MASTER LIST].SaturdayTF, [QMC MASTER
LIST].SundayTF, [QMC MASTER LIST].CriticalIssueTF, [QMC MASTER LIST].ID,
[QMC MASTER LIST].Active, [QMC MASTER LIST].[CamoTesting]
FROM [QMC MASTER LIST] where [MountainsTF]=True
union all
SELECT "EXT - Hot & Dry" as Fleet_Activity, [QMC MASTER LIST].BinstoOther,
[QMC MASTER LIST].[CCC's], [QMC MASTER LIST].VFG, [QMC MASTER LIST].VRT, [QMC
MASTER LIST].[GQRS CAT], [QMC MASTER LIST].ACTION, [QMC MASTER LIST].[Work
Element Description], [QMC MASTER LIST].Frequency, [QMC MASTER LIST].[WES#],
[QMC MASTER LIST].Source, [QMC MASTER LIST].MondayTF, [QMC MASTER
LIST].TuesdayTF, [QMC MASTER LIST].WednesdayTF, [QMC MASTER LIST].ThursdayTF,
[QMC MASTER LIST].FridayTf, [QMC MASTER LIST].SaturdayTF, [QMC MASTER
LIST].SundayTF, [QMC MASTER LIST].CriticalIssueTF, [QMC MASTER LIST].ID,
[QMC MASTER LIST].Active, [QMC MASTER LIST].[CamoTesting]
FROM [QMC MASTER LIST] where [HotDryTF]=True
union all
SELECT "EXT - Cold" as Fleet_Activity, [QMC MASTER LIST].BinstoOther, [QMC
MASTER LIST].[CCC's], [QMC MASTER LIST].VFG, [QMC MASTER LIST].VRT, [QMC
MASTER LIST].[GQRS CAT], [QMC MASTER LIST].ACTION, [QMC MASTER LIST].[Work
Element Description], [QMC MASTER LIST].Frequency, [QMC MASTER LIST].[WES#],
[QMC MASTER LIST].Source, [QMC MASTER LIST].MondayTF, [QMC MASTER
LIST].TuesdayTF, [QMC MASTER LIST].WednesdayTF, [QMC MASTER LIST].ThursdayTF,
[QMC MASTER LIST].FridayTf, [QMC MASTER LIST].SaturdayTF, [QMC MASTER
LIST].SundayTF, [QMC MASTER LIST].CriticalIssueTF, [QMC MASTER LIST].ID,
[QMC MASTER LIST].Active, [QMC MASTER LIST].[CamoTesting]
FROM [QMC MASTER LIST] where [ColdTF]=True
union all
SELECT "Trailer Tow" as Fleet_Activity, [QMC MASTER LIST].BinstoOther, [QMC
MASTER LIST].[CCC's], [QMC MASTER LIST].VFG, [QMC MASTER LIST].VRT, [QMC
MASTER LIST].[GQRS CAT], [QMC MASTER LIST].ACTION, [QMC MASTER LIST].[Work
Element Description], [QMC MASTER LIST].Frequency, [QMC MASTER LIST].[WES#],
[QMC MASTER LIST].Source, [QMC MASTER LIST].MondayTF, [QMC MASTER
LIST].TuesdayTF, [QMC MASTER LIST].WednesdayTF, [QMC MASTER LIST].ThursdayTF,
[QMC MASTER LIST].FridayTf, [QMC MASTER LIST].SaturdayTF, [QMC MASTER
LIST].SundayTF, [QMC MASTER LIST].CriticalIssueTF, [QMC MASTER LIST].ID,
[QMC MASTER LIST].Active, [QMC MASTER LIST].[CamoTesting]
FROM [QMC MASTER LIST] where [TrailerTowTF]=True
union all
SELECT "Vehicle Prep" as Fleet_Activity, [QMC MASTER LIST].BinstoOther, [QMC
MASTER LIST].[CCC's], [QMC MASTER LIST].VFG, [QMC MASTER LIST].VRT, [QMC
MASTER LIST].[GQRS CAT], [QMC MASTER LIST].ACTION, [QMC MASTER LIST].[Work
Element Description], [QMC MASTER LIST].Frequency, [QMC MASTER LIST].[WES#],
[QMC MASTER LIST].Source, [QMC MASTER LIST].MondayTF, [QMC MASTER
LIST].TuesdayTF, [QMC MASTER LIST].WednesdayTF, [QMC MASTER LIST].ThursdayTF,
[QMC MASTER LIST].FridayTf, [QMC MASTER LIST].SaturdayTF, [QMC MASTER
LIST].SundayTF, [QMC MASTER LIST].CriticalIssueTF, [QMC MASTER LIST].ID,
[QMC MASTER LIST].Active, [QMC MASTER LIST].[CamoTesting]
FROM [QMC MASTER LIST] where [VehiclePrepTF]=True
union all
SELECT "4x4 Off Road" as Fleet_Activity, [QMC MASTER LIST].BinstoOther, [QMC
MASTER LIST].[CCC's], [QMC MASTER LIST].VFG, [QMC MASTER LIST].VRT, [QMC
MASTER LIST].[GQRS CAT], [QMC MASTER LIST].ACTION, [QMC MASTER LIST].[Work
Element Description], [QMC MASTER LIST].Frequency, [QMC MASTER LIST].[WES#],
[QMC MASTER LIST].Source, [QMC MASTER LIST].MondayTF, [QMC MASTER
LIST].TuesdayTF, [QMC MASTER LIST].WednesdayTF, [QMC MASTER LIST].ThursdayTF,
[QMC MASTER LIST].FridayTf, [QMC MASTER LIST].SaturdayTF, [QMC MASTER
LIST].SundayTF, [QMC MASTER LIST].CriticalIssueTF, [QMC MASTER LIST].ID,
[QMC MASTER LIST].Active, [QMC MASTER LIST].[CamoTesting]
FROM [QMC MASTER LIST] where [4x4OffRoadTF]=True
UNION ALL
SELECT "Pre-Drive Checklist" as Fleet_Activity, [QMC MASTER
LIST].BinstoOther, [QMC MASTER LIST].[CCC's], [QMC MASTER LIST].VFG, [QMC
MASTER LIST].VRT, [QMC MASTER LIST].[GQRS CAT], [QMC MASTER LIST].ACTION,
[QMC MASTER LIST].[Work Element Description], [QMC MASTER LIST].Frequency,
[QMC MASTER LIST].[WES#], [QMC MASTER LIST].Source, [QMC MASTER
LIST].MondayTF, [QMC MASTER LIST].TuesdayTF, [QMC MASTER LIST].WednesdayTF,
[QMC MASTER LIST].ThursdayTF, [QMC MASTER LIST].FridayTf, [QMC MASTER
LIST].SaturdayTF, [QMC MASTER LIST].SundayTF, [QMC MASTER
LIST].CriticalIssueTF, [QMC MASTER LIST].ID, [QMC MASTER LIST].Active, [QMC
MASTER LIST].[CamoTesting]
FROM [QMC MASTER LIST] where [PDITF]=True
UNION ALL SELECT "High Mileage" as Fleet_Activity, [QMC MASTER
LIST].BinstoOther, [QMC MASTER LIST].[CCC's], [QMC MASTER LIST].VFG, [QMC
MASTER LIST].VRT, [QMC MASTER LIST].[GQRS CAT], [QMC MASTER LIST].ACTION,
[QMC MASTER LIST].[Work Element Description], [QMC MASTER LIST].Frequency,
[QMC MASTER LIST].[WES#], [QMC MASTER LIST].Source, [QMC MASTER
LIST].MondayTF, [QMC MASTER LIST].TuesdayTF, [QMC MASTER LIST].WednesdayTF,
[QMC MASTER LIST].ThursdayTF, [QMC MASTER LIST].FridayTf, [QMC MASTER
LIST].SaturdayTF, [QMC MASTER LIST].SundayTF, [QMC MASTER
LIST].CriticalIssueTF, [QMC MASTER LIST].ID, [QMC MASTER LIST].Active, [QMC
MASTER LIST].[CamoTesting]
FROM [QMC MASTER LIST] where [HighMileageTF]=True
UNION ALL SELECT "Observation Training" as Fleet_Activity, [QMC MASTER
LIST].BinstoOther, [QMC MASTER LIST].[CCC's], [QMC MASTER LIST].VFG, [QMC
MASTER LIST].VRT, [QMC MASTER LIST].[GQRS CAT], [QMC MASTER LIST].ACTION,
[QMC MASTER LIST].[Work Element Description], [QMC MASTER LIST].Frequency,
[QMC MASTER LIST].[WES#], [QMC MASTER LIST].Source, [QMC MASTER
LIST].MondayTF, [QMC MASTER LIST].TuesdayTF, [QMC MASTER LIST].WednesdayTF,
[QMC MASTER LIST].ThursdayTF, [QMC MASTER LIST].FridayTf, [QMC MASTER
LIST].SaturdayTF, [QMC MASTER LIST].SundayTF, [QMC MASTER
LIST].CriticalIssueTF, [QMC MASTER LIST].ID, [QMC MASTER LIST].Active, [QMC
MASTER LIST].[CamoTesting]
FROM [QMC MASTER LIST] where [ACTION]="Observe"
UNION ALL SELECT "Removed" as Fleet_Activity, [QMC MASTER LIST].BinstoOther,
[QMC MASTER LIST].[CCC's], [QMC MASTER LIST].VFG, [QMC MASTER LIST].VRT, [QMC
MASTER LIST].[GQRS CAT], [QMC MASTER LIST].ACTION, [QMC MASTER LIST].[Work
Element Description], [QMC MASTER LIST].Frequency, [QMC MASTER LIST].[WES#],
[QMC MASTER LIST].Source, [QMC MASTER LIST].MondayTF, [QMC MASTER
LIST].TuesdayTF, [QMC MASTER LIST].WednesdayTF, [QMC MASTER LIST].ThursdayTF,
[QMC MASTER LIST].FridayTf, [QMC MASTER LIST].SaturdayTF, [QMC MASTER
LIST].SundayTF, [QMC MASTER LIST].CriticalIssueTF, [QMC MASTER LIST].ID,
[QMC MASTER LIST].Active, [QMC MASTER LIST].[CamoTesting]
FROM [QMC MASTER LIST] where [Active]=False
UNION ALL SELECT "Pre-Camo Inspection" as Fleet_Activity, [QMC MASTER
LIST].BinstoOther, [QMC MASTER LIST].[CCC's], [QMC MASTER LIST].VFG, [QMC
MASTER LIST].VRT, [QMC MASTER LIST].[GQRS CAT], [QMC MASTER LIST].ACTION,
[QMC MASTER LIST].[Work Element Description], [QMC MASTER LIST].Frequency,
[QMC MASTER LIST].[WES#], [QMC MASTER LIST].Source, [QMC MASTER
LIST].MondayTF, [QMC MASTER LIST].TuesdayTF, [QMC MASTER LIST].WednesdayTF,
[QMC MASTER LIST].ThursdayTF, [QMC MASTER LIST].FridayTf, [QMC MASTER
LIST].SaturdayTF, [QMC MASTER LIST].SundayTF, [QMC MASTER
LIST].CriticalIssueTF, [QMC MASTER LIST].ID, [QMC MASTER LIST].Active, [QMC
MASTER LIST].[CamoTesting]
FROM [QMC MASTER LIST] where [CamoTesting]=True
UNION ALL SELECT "Overnight" as Fleet_Activity, [QMC MASTER
LIST].BinstoOther, [QMC MASTER LIST].[CCC's], [QMC MASTER LIST].VFG, [QMC
MASTER LIST].VRT, [QMC MASTER LIST].[GQRS CAT], [QMC MASTER LIST].ACTION,
[QMC MASTER LIST].[Work Element Description], [QMC MASTER LIST].Frequency,
[QMC MASTER LIST].[WES#], [QMC MASTER LIST].Source, [QMC MASTER
LIST].MondayTF, [QMC MASTER LIST].TuesdayTF, [QMC MASTER LIST].WednesdayTF,
[QMC MASTER LIST].ThursdayTF, [QMC MASTER LIST].FridayTf, [QMC MASTER
LIST].SaturdayTF, [QMC MASTER LIST].SundayTF, [QMC MASTER
LIST].CriticalIssueTF, [QMC MASTER LIST].ID, [QMC MASTER LIST].Active, [QMC
MASTER LIST].[CamoTesting]
FROM [QMC MASTER LIST] where [OvernightTF]=True
UNION ALL SELECT "Service" as Fleet_Activity, [QMC MASTER LIST].BinstoOther,
[QMC MASTER LIST].[CCC's], [QMC MASTER LIST].VFG, [QMC MASTER LIST].VRT, [QMC
MASTER LIST].[GQRS CAT], [QMC MASTER LIST].ACTION, [QMC MASTER LIST].[Work
Element Description], [QMC MASTER LIST].Frequency, [QMC MASTER LIST].[WES#],
[QMC MASTER LIST].Source, [QMC MASTER LIST].MondayTF, [QMC MASTER
LIST].TuesdayTF, [QMC MASTER LIST].WednesdayTF, [QMC MASTER LIST].ThursdayTF,
[QMC MASTER LIST].FridayTf, [QMC MASTER LIST].SaturdayTF, [QMC MASTER
LIST].SundayTF, [QMC MASTER LIST].CriticalIssueTF, [QMC MASTER LIST].ID,
[QMC MASTER LIST].Active, [QMC MASTER LIST].[CamoTesting]
FROM [QMC MASTER LIST] where [ServiceTF]=True;
 
I have successfully exported this query to excel, and it has around 3862
records, and 14 fields. WHY IS IT DYING!!!!!!
--
BlueWolverine
MSE - Mech. Eng.
Go BLUE!


BlueWolverine said:
Hello,
Running MS Access 2003 on XP Pro.

I have discovered a very potential root cause for my most recent posting,
about Run Time Error 3035.

I have a query that causes an error msg that says "System Resources Exceeded".

It has never done that before. While I have added data to what this query
would pull, I didn't think I'd added that much, if really anything at all.


Here is the query that dies: (followed by the query it pulls from)

SELECT "Monday" AS DayOfWeek, q_FA.Fleet_Activity, q_FA.BinstoOther,
q_FA.[CCC's], q_FA.VFG, q_FA.VRT, q_FA.[GQRS CAT], q_FA.ACTION, q_FA.[Work
Element Description], q_FA.Frequency, q_FA.[WES#], q_FA.Source, q_FA.ID,
q_FA.Active
FROM q_FA
WHERE [MondayTF]=True
union all
SELECT "Tuesday" AS DayOfWeek, q_FA.Fleet_Activity, q_FA.BinstoOther,
q_FA.[CCC's], q_FA.VFG, q_FA.VRT, q_FA.[GQRS CAT], q_FA.ACTION, q_FA.[Work
Element Description], q_FA.Frequency, q_FA.[WES#], q_FA.Source, q_FA.ID,
q_FA.Active
FROM q_FA
WHERE [TuesdayTF]=True
union all
SELECT "Wednesday" AS DayOfWeek, q_FA.Fleet_Activity, q_FA.BinstoOther,
q_FA.[CCC's], q_FA.VFG, q_FA.VRT, q_FA.[GQRS CAT], q_FA.ACTION, q_FA.[Work
Element Description], q_FA.Frequency, q_FA.[WES#], q_FA.Source, q_FA.ID,
q_FA.Active
FROM q_FA
WHERE [WednesdayTF]=True
union all
SELECT "Thursday" AS DayOfWeek, q_FA.Fleet_Activity, q_FA.BinstoOther,
q_FA.[CCC's], q_FA.VFG, q_FA.VRT, q_FA.[GQRS CAT], q_FA.ACTION, q_FA.[Work
Element Description], q_FA.Frequency, q_FA.[WES#], q_FA.Source, q_FA.ID,
q_FA.Active
FROM q_FA
WHERE [ThursdayTF]=True
union all
SELECT "Friday" AS DayOfWeek, q_FA.Fleet_Activity, q_FA.BinstoOther,
q_FA.[CCC's], q_FA.VFG, q_FA.VRT, q_FA.[GQRS CAT], q_FA.ACTION, q_FA.[Work
Element Description], q_FA.Frequency, q_FA.[WES#], q_FA.Source, q_FA.ID,
q_FA.Active
FROM q_FA
WHERE [FridayTF]=True
union all
SELECT "Saturday" AS DayOfWeek, q_FA.Fleet_Activity, q_FA.BinstoOther,
q_FA.[CCC's], q_FA.VFG, q_FA.VRT, q_FA.[GQRS CAT], q_FA.ACTION, q_FA.[Work
Element Description], q_FA.Frequency, q_FA.[WES#], q_FA.Source, q_FA.ID,
q_FA.Active
FROM q_FA
WHERE [SaturdayTF]=True
UNION ALL SELECT "Sunday" AS DayOfWeek, q_FA.Fleet_Activity,
q_FA.BinstoOther, q_FA.[CCC's], q_FA.VFG, q_FA.VRT, q_FA.[GQRS CAT],
q_FA.ACTION, q_FA.[Work Element Description], q_FA.Frequency, q_FA.[WES#],
q_FA.Source, q_FA.ID, q_FA.Active
FROM q_FA
WHERE [SundayTF]=True
UNION ALL SELECT "Removed" AS DayOfWeek, q_FA.Fleet_Activity,
q_FA.BinstoOther, q_FA.[CCC's], q_FA.VFG, q_FA.VRT, q_FA.[GQRS CAT],
q_FA.ACTION, q_FA.[Work Element Description], q_FA.Frequency, q_FA.[WES#],
q_FA.Source, q_FA.ID, q_FA.Active
FROM q_FA
WHERE [Active]=False
UNION ALL SELECT "N/A" AS DayOfWeek, q_FA.Fleet_Activity, q_FA.BinstoOther,
q_FA.[CCC's], q_FA.VFG, q_FA.VRT, q_FA.[GQRS CAT], q_FA.ACTION, q_FA.[Work
Element Description], q_FA.Frequency, q_FA.[WES#], q_FA.Source, q_FA.ID,
q_FA.Active
FROM q_FA
WHERE ([SundayTF]=False AND [SaturdayTF]=False AND [MondayTF]=False AND
[TuesdayTF]=False AND [WednesdayTF]=False AND [ThursdayTF]=False AND
[FridayTF]=False);


<<Q_FA>>
SELECT "Duty Cycle" as Fleet_Activity, [QMC MASTER LIST].BinstoOther, [QMC
MASTER LIST].[CCC's], [QMC MASTER LIST].VFG, [QMC MASTER LIST].VRT, [QMC
MASTER LIST].[GQRS CAT], [QMC MASTER LIST].ACTION, [QMC MASTER LIST].[Work
Element Description], [QMC MASTER LIST].Frequency, [QMC MASTER LIST].[WES#],
[QMC MASTER LIST].Source, [QMC MASTER LIST].MondayTF, [QMC MASTER
LIST].TuesdayTF, [QMC MASTER LIST].WednesdayTF, [QMC MASTER LIST].ThursdayTF,
[QMC MASTER LIST].FridayTf, [QMC MASTER LIST].SaturdayTF, [QMC MASTER
LIST].SundayTF, [QMC MASTER LIST].CriticalIssueTF, [QMC MASTER LIST].ID,
[QMC MASTER LIST].Active, [QMC MASTER LIST].[CamoTesting]
FROM [QMC MASTER LIST] where [DutyCycleTF]=True
union all
SELECT "Shakedown" as Fleet_Activity, [QMC MASTER LIST].BinstoOther, [QMC
MASTER LIST].[CCC's], [QMC MASTER LIST].VFG, [QMC MASTER LIST].VRT, [QMC
MASTER LIST].[GQRS CAT], [QMC MASTER LIST].ACTION, [QMC MASTER LIST].[Work
Element Description], [QMC MASTER LIST].Frequency, [QMC MASTER LIST].[WES#],
[QMC MASTER LIST].Source, [QMC MASTER LIST].MondayTF, [QMC MASTER
LIST].TuesdayTF, [QMC MASTER LIST].WednesdayTF, [QMC MASTER LIST].ThursdayTF,
[QMC MASTER LIST].FridayTf, [QMC MASTER LIST].SaturdayTF, [QMC MASTER
LIST].SundayTF, [QMC MASTER LIST].CriticalIssueTF, [QMC MASTER LIST].ID,
[QMC MASTER LIST].Active, [QMC MASTER LIST].[CamoTesting]
FROM [QMC MASTER LIST] where [ShakedownTF]=True
UNION ALL SELECT "Extended" as Fleet_Activity, [QMC MASTER
LIST].BinstoOther, [QMC MASTER LIST].[CCC's], [QMC MASTER LIST].VFG, [QMC
MASTER LIST].VRT, [QMC MASTER LIST].[GQRS CAT], [QMC MASTER LIST].ACTION,
[QMC MASTER LIST].[Work Element Description], [QMC MASTER LIST].Frequency,
[QMC MASTER LIST].[WES#], [QMC MASTER LIST].Source, [QMC MASTER
LIST].MondayTF, [QMC MASTER LIST].TuesdayTF, [QMC MASTER LIST].WednesdayTF,
[QMC MASTER LIST].ThursdayTF, [QMC MASTER LIST].FridayTf, [QMC MASTER
LIST].SaturdayTF, [QMC MASTER LIST].SundayTF, [QMC MASTER
LIST].CriticalIssueTF, [QMC MASTER LIST].ID, [QMC MASTER LIST].Active, [QMC
MASTER LIST].[CamoTesting]
FROM [QMC MASTER LIST] where [ExtendedTF]=True
union all
SELECT "EXT - Hot & Humid" as Fleet_Activity, [QMC MASTER LIST].BinstoOther,
[QMC MASTER LIST].[CCC's], [QMC MASTER LIST].VFG, [QMC MASTER LIST].VRT, [QMC
MASTER LIST].[GQRS CAT], [QMC MASTER LIST].ACTION, [QMC MASTER LIST].[Work
Element Description], [QMC MASTER LIST].Frequency, [QMC MASTER LIST].[WES#],
[QMC MASTER LIST].Source, [QMC MASTER LIST].MondayTF, [QMC MASTER
LIST].TuesdayTF, [QMC MASTER LIST].WednesdayTF, [QMC MASTER LIST].ThursdayTF,
[QMC MASTER LIST].FridayTf, [QMC MASTER LIST].SaturdayTF, [QMC MASTER
LIST].SundayTF, [QMC MASTER LIST].CriticalIssueTF, [QMC MASTER LIST].ID,
[QMC MASTER LIST].Active, [QMC MASTER LIST].[CamoTesting]
FROM [QMC MASTER LIST] where [HotHumidTF]=True
union all
SELECT "EXT - Mountains" as Fleet_Activity, [QMC MASTER LIST].BinstoOther,
[QMC MASTER LIST].[CCC's], [QMC MASTER LIST].VFG, [QMC MASTER LIST].VRT, [QMC
MASTER LIST].[GQRS CAT], [QMC MASTER LIST].ACTION, [QMC MASTER LIST].[Work
Element Description], [QMC MASTER LIST].Frequency, [QMC MASTER LIST].[WES#],
[QMC MASTER LIST].Source, [QMC MASTER LIST].MondayTF, [QMC MASTER
LIST].TuesdayTF, [QMC MASTER LIST].WednesdayTF, [QMC MASTER LIST].ThursdayTF,
[QMC MASTER LIST].FridayTf, [QMC MASTER LIST].SaturdayTF, [QMC MASTER
LIST].SundayTF, [QMC MASTER LIST].CriticalIssueTF, [QMC MASTER LIST].ID,
[QMC MASTER LIST].Active, [QMC MASTER LIST].[CamoTesting]
FROM [QMC MASTER LIST] where [MountainsTF]=True
union all
SELECT "EXT - Hot & Dry" as Fleet_Activity, [QMC MASTER LIST].BinstoOther,
[QMC MASTER LIST].[CCC's], [QMC MASTER LIST].VFG, [QMC MASTER LIST].VRT, [QMC
MASTER LIST].[GQRS CAT], [QMC MASTER LIST].ACTION, [QMC MASTER LIST].[Work
Element Description], [QMC MASTER LIST].Frequency, [QMC MASTER LIST].[WES#],
[QMC MASTER LIST].Source, [QMC MASTER LIST].MondayTF, [QMC MASTER
LIST].TuesdayTF, [QMC MASTER LIST].WednesdayTF, [QMC MASTER LIST].ThursdayTF,
[QMC MASTER LIST].FridayTf, [QMC MASTER LIST].SaturdayTF, [QMC MASTER
LIST].SundayTF, [QMC MASTER LIST].CriticalIssueTF, [QMC MASTER LIST].ID,
[QMC MASTER LIST].Active, [QMC MASTER LIST].[CamoTesting]
FROM [QMC MASTER LIST] where [HotDryTF]=True
union all
SELECT "EXT - Cold" as Fleet_Activity, [QMC MASTER LIST].BinstoOther, [QMC
MASTER LIST].[CCC's], [QMC MASTER LIST].VFG, [QMC MASTER LIST].VRT, [QMC
MASTER LIST].[GQRS CAT], [QMC MASTER LIST].ACTION, [QMC MASTER LIST].[Work
Element Description], [QMC MASTER LIST].Frequency, [QMC MASTER LIST].[WES#],
[QMC MASTER LIST].Source, [QMC MASTER LIST].MondayTF, [QMC MASTER
LIST].TuesdayTF, [QMC MASTER LIST].WednesdayTF, [QMC MASTER LIST].ThursdayTF,
[QMC MASTER LIST].FridayTf, [QMC MASTER LIST].SaturdayTF, [QMC MASTER
LIST].SundayTF, [QMC MASTER LIST].CriticalIssueTF, [QMC MASTER LIST].ID,
[QMC MASTER LIST].Active, [QMC MASTER LIST].[CamoTesting]
FROM [QMC MASTER LIST] where [ColdTF]=True
union all
SELECT "Trailer Tow" as Fleet_Activity, [QMC MASTER LIST].BinstoOther, [QMC
MASTER LIST].[CCC's], [QMC MASTER LIST].VFG, [QMC MASTER LIST].VRT, [QMC
MASTER LIST].[GQRS CAT], [QMC MASTER LIST].ACTION, [QMC MASTER LIST].[Work
Element Description], [QMC MASTER LIST].Frequency, [QMC MASTER LIST].[WES#],
[QMC MASTER LIST].Source, [QMC MASTER LIST].MondayTF, [QMC MASTER
LIST].TuesdayTF, [QMC MASTER LIST].WednesdayTF, [QMC MASTER LIST].ThursdayTF,
[QMC MASTER LIST].FridayTf, [QMC MASTER LIST].SaturdayTF, [QMC MASTER
LIST].SundayTF, [QMC MASTER LIST].CriticalIssueTF, [QMC MASTER LIST].ID,
[QMC MASTER LIST].Active, [QMC MASTER LIST].[CamoTesting]
FROM [QMC MASTER LIST] where [TrailerTowTF]=True
union all
SELECT "Vehicle Prep" as Fleet_Activity, [QMC MASTER LIST].BinstoOther, [QMC
MASTER LIST].[CCC's], [QMC MASTER LIST].VFG, [QMC MASTER LIST].VRT, [QMC
MASTER LIST].[GQRS CAT], [QMC MASTER LIST].ACTION, [QMC MASTER LIST].[Work
Element Description], [QMC MASTER LIST].Frequency, [QMC MASTER LIST].[WES#],
[QMC MASTER LIST].Source, [QMC MASTER LIST].MondayTF, [QMC MASTER
LIST].TuesdayTF, [QMC MASTER LIST].WednesdayTF, [QMC MASTER LIST].ThursdayTF,
[QMC MASTER LIST].FridayTf, [QMC MASTER LIST].SaturdayTF, [QMC MASTER
LIST].SundayTF, [QMC MASTER LIST].CriticalIssueTF, [QMC MASTER LIST].ID,
[QMC MASTER LIST].Active, [QMC MASTER LIST].[CamoTesting]
FROM [QMC MASTER LIST] where [VehiclePrepTF]=True
union all
SELECT "4x4 Off Road" as Fleet_Activity, [QMC MASTER LIST].BinstoOther, [QMC
MASTER LIST].[CCC's], [QMC MASTER LIST].VFG, [QMC MASTER LIST].VRT, [QMC
MASTER LIST].[GQRS CAT], [QMC MASTER LIST].ACTION, [QMC MASTER LIST].[Work
Element Description], [QMC MASTER LIST].Frequency, [QMC MASTER LIST].[WES#],
[QMC MASTER LIST].Source, [QMC MASTER LIST].MondayTF, [QMC MASTER
LIST].TuesdayTF, [QMC MASTER LIST].WednesdayTF, [QMC MASTER LIST].ThursdayTF,
[QMC MASTER LIST].FridayTf, [QMC MASTER LIST].SaturdayTF, [QMC MASTER
LIST].SundayTF, [QMC MASTER LIST].CriticalIssueTF, [QMC MASTER LIST].ID,
[QMC MASTER LIST].Active, [QMC MASTER LIST].[CamoTesting]
FROM [QMC MASTER LIST] where [4x4OffRoadTF]=True
UNION ALL
SELECT "Pre-Drive Checklist" as Fleet_Activity, [QMC MASTER
LIST].BinstoOther, [QMC MASTER LIST].[CCC's], [QMC MASTER LIST].VFG, [QMC
MASTER LIST].VRT, [QMC MASTER LIST].[GQRS CAT], [QMC MASTER LIST].ACTION,
[QMC MASTER LIST].[Work Element Description], [QMC MASTER LIST].Frequency,
[QMC MASTER LIST].[WES#], [QMC MASTER LIST].Source, [QMC MASTER
LIST].MondayTF, [QMC MASTER LIST].TuesdayTF, [QMC MASTER LIST].WednesdayTF,
[QMC MASTER LIST].ThursdayTF, [QMC MASTER LIST].FridayTf, [QMC MASTER
LIST].SaturdayTF, [QMC MASTER LIST].SundayTF, [QMC MASTER
LIST].CriticalIssueTF, [QMC MASTER LIST].ID, [QMC MASTER LIST].Active, [QMC
MASTER LIST].[CamoTesting]
FROM [QMC MASTER LIST] where [PDITF]=True
UNION ALL SELECT "High Mileage" as Fleet_Activity, [QMC MASTER
LIST].BinstoOther, [QMC MASTER LIST].[CCC's], [QMC MASTER LIST].VFG, [QMC
MASTER LIST].VRT, [QMC MASTER LIST].[GQRS CAT], [QMC MASTER LIST].ACTION,
[QMC MASTER LIST].[Work Element Description], [QMC MASTER LIST].Frequency,
[QMC MASTER LIST].[WES#], [QMC MASTER LIST].Source, [QMC MASTER
LIST].MondayTF, [QMC MASTER LIST].TuesdayTF, [QMC MASTER LIST].WednesdayTF,
[QMC MASTER LIST].ThursdayTF, [QMC MASTER LIST].FridayTf, [QMC MASTER
LIST].SaturdayTF, [QMC MASTER LIST].SundayTF, [QMC MASTER
LIST].CriticalIssueTF, [QMC MASTER LIST].ID, [QMC MASTER LIST].Active, [QMC
MASTER LIST].[CamoTesting]
FROM [QMC MASTER LIST] where [HighMileageTF]=True
UNION ALL SELECT "Observation Training" as Fleet_Activity, [QMC MASTER
LIST].BinstoOther, [QMC MASTER LIST].[CCC's], [QMC MASTER LIST].VFG, [QMC
MASTER LIST].VRT, [QMC MASTER LIST].[GQRS CAT], [QMC MASTER LIST].ACTION,
[QMC MASTER LIST].[Work Element Description], [QMC MASTER LIST].Frequency,
[QMC MASTER LIST].[WES#], [QMC MASTER LIST].Source, [QMC MASTER
LIST].MondayTF, [QMC MASTER LIST].TuesdayTF, [QMC MASTER LIST].WednesdayTF,
[QMC MASTER LIST].ThursdayTF, [QMC MASTER LIST].FridayTf, [QMC MASTER
LIST].SaturdayTF, [QMC MASTER LIST].SundayTF, [QMC MASTER
LIST].CriticalIssueTF, [QMC MASTER LIST].ID, [QMC MASTER LIST].Active, [QMC
MASTER LIST].[CamoTesting]
FROM [QMC MASTER LIST] where [ACTION]="Observe"
UNION ALL SELECT "Removed" as Fleet_Activity, [QMC MASTER LIST].BinstoOther,
[QMC MASTER LIST].[CCC's], [QMC MASTER LIST].VFG, [QMC MASTER LIST].VRT, [QMC
MASTER LIST].[GQRS CAT], [QMC MASTER LIST].ACTION, [QMC MASTER LIST].[Work
Element Description], [QMC MASTER LIST].Frequency, [QMC MASTER LIST].[WES#],
[QMC MASTER LIST].Source, [QMC MASTER LIST].MondayTF, [QMC MASTER
LIST].TuesdayTF, [QMC MASTER LIST].WednesdayTF, [QMC MASTER LIST].ThursdayTF,
[QMC MASTER LIST].FridayTf, [QMC MASTER LIST].SaturdayTF, [QMC MASTER
LIST].SundayTF, [QMC MASTER LIST].CriticalIssueTF, [QMC MASTER LIST].ID,
[QMC MASTER LIST].Active, [QMC MASTER LIST].[CamoTesting]
FROM [QMC MASTER LIST] where [Active]=False
UNION ALL SELECT "Pre-Camo Inspection" as Fleet_Activity, [QMC MASTER
LIST].BinstoOther, [QMC MASTER LIST].[CCC's], [QMC MASTER LIST].VFG, [QMC
MASTER LIST].VRT, [QMC MASTER LIST].[GQRS CAT], [QMC MASTER LIST].ACTION,
[QMC MASTER LIST].[Work Element Description], [QMC MASTER LIST].Frequency,
[QMC MASTER LIST].[WES#], [QMC MASTER LIST].Source, [QMC MASTER
LIST].MondayTF, [QMC MASTER LIST].TuesdayTF, [QMC MASTER LIST].WednesdayTF,
[QMC MASTER LIST].ThursdayTF, [QMC MASTER LIST].FridayTf, [QMC MASTER
LIST].SaturdayTF, [QMC MASTER LIST].SundayTF, [QMC MASTER
LIST].CriticalIssueTF, [QMC MASTER LIST].ID, [QMC MASTER LIST].Active, [QMC
MASTER LIST].[CamoTesting]
FROM [QMC MASTER LIST] where [CamoTesting]=True
UNION ALL SELECT "Overnight" as Fleet_Activity, [QMC MASTER
LIST].BinstoOther, [QMC MASTER LIST].[CCC's], [QMC MASTER LIST].VFG, [QMC
MASTER LIST].VRT, [QMC MASTER LIST].[GQRS CAT], [QMC MASTER LIST].ACTION,
[QMC MASTER LIST].[Work Element Description], [QMC MASTER LIST].Frequency,
[QMC MASTER LIST].[WES#], [QMC MASTER LIST].Source, [QMC MASTER
LIST].MondayTF, [QMC MASTER LIST].TuesdayTF, [QMC MASTER LIST].WednesdayTF,
[QMC MASTER LIST].ThursdayTF, [QMC MASTER LIST].FridayTf, [QMC MASTER
LIST].SaturdayTF, [QMC MASTER LIST].SundayTF, [QMC MASTER
LIST].CriticalIssueTF, [QMC MASTER LIST].ID, [QMC MASTER LIST].Active, [QMC
MASTER LIST].[CamoTesting]
FROM [QMC MASTER LIST] where [OvernightTF]=True
UNION ALL SELECT "Service" as Fleet_Activity, [QMC MASTER LIST].BinstoOther,
[QMC MASTER LIST].[CCC's], [QMC MASTER LIST].VFG, [QMC MASTER LIST].VRT, [QMC
MASTER LIST].[GQRS CAT], [QMC MASTER LIST].ACTION, [QMC MASTER LIST].[Work
Element Description], [QMC MASTER LIST].Frequency, [QMC MASTER LIST].[WES#],
[QMC MASTER LIST].Source, [QMC MASTER LIST].MondayTF, [QMC MASTER
LIST].TuesdayTF, [QMC MASTER LIST].WednesdayTF, [QMC MASTER LIST].ThursdayTF,
[QMC MASTER LIST].FridayTf, [QMC MASTER LIST].SaturdayTF, [QMC MASTER
LIST].SundayTF, [QMC MASTER LIST].CriticalIssueTF, [QMC MASTER LIST].ID,
[QMC MASTER LIST].Active, [QMC MASTER LIST].[CamoTesting]
FROM [QMC MASTER LIST] where [ServiceTF]=True;
Click to expand...
 
So I took out ALMOST all the fields out of these queries such that later on I
have to use Join queries back to the original table (off of ID) and it works
because it's not lugging around so much BS.

I guess my query was too fat.
--
BlueWolverine
MSE - Mech. Eng.
Go BLUE!


BlueWolverine said:
I have successfully exported this query to excel, and it has around 3862
records, and 14 fields. WHY IS IT DYING!!!!!!
--
BlueWolverine
MSE - Mech. Eng.
Go BLUE!


BlueWolverine said:
Hello,
Running MS Access 2003 on XP Pro.

I have discovered a very potential root cause for my most recent posting,
about Run Time Error 3035.

I have a query that causes an error msg that says "System Resources Exceeded".

It has never done that before. While I have added data to what this query
would pull, I didn't think I'd added that much, if really anything at all.


Here is the query that dies: (followed by the query it pulls from)

SELECT "Monday" AS DayOfWeek, q_FA.Fleet_Activity, q_FA.BinstoOther,
q_FA.[CCC's], q_FA.VFG, q_FA.VRT, q_FA.[GQRS CAT], q_FA.ACTION, q_FA.[Work
Element Description], q_FA.Frequency, q_FA.[WES#], q_FA.Source, q_FA.ID,
q_FA.Active
FROM q_FA
WHERE [MondayTF]=True
union all
SELECT "Tuesday" AS DayOfWeek, q_FA.Fleet_Activity, q_FA.BinstoOther,
q_FA.[CCC's], q_FA.VFG, q_FA.VRT, q_FA.[GQRS CAT], q_FA.ACTION, q_FA.[Work
Element Description], q_FA.Frequency, q_FA.[WES#], q_FA.Source, q_FA.ID,
q_FA.Active
FROM q_FA
WHERE [TuesdayTF]=True
union all
SELECT "Wednesday" AS DayOfWeek, q_FA.Fleet_Activity, q_FA.BinstoOther,
q_FA.[CCC's], q_FA.VFG, q_FA.VRT, q_FA.[GQRS CAT], q_FA.ACTION, q_FA.[Work
Element Description], q_FA.Frequency, q_FA.[WES#], q_FA.Source, q_FA.ID,
q_FA.Active
FROM q_FA
WHERE [WednesdayTF]=True
union all
SELECT "Thursday" AS DayOfWeek, q_FA.Fleet_Activity, q_FA.BinstoOther,
q_FA.[CCC's], q_FA.VFG, q_FA.VRT, q_FA.[GQRS CAT], q_FA.ACTION, q_FA.[Work
Element Description], q_FA.Frequency, q_FA.[WES#], q_FA.Source, q_FA.ID,
q_FA.Active
FROM q_FA
WHERE [ThursdayTF]=True
union all
SELECT "Friday" AS DayOfWeek, q_FA.Fleet_Activity, q_FA.BinstoOther,
q_FA.[CCC's], q_FA.VFG, q_FA.VRT, q_FA.[GQRS CAT], q_FA.ACTION, q_FA.[Work
Element Description], q_FA.Frequency, q_FA.[WES#], q_FA.Source, q_FA.ID,
q_FA.Active
FROM q_FA
WHERE [FridayTF]=True
union all
SELECT "Saturday" AS DayOfWeek, q_FA.Fleet_Activity, q_FA.BinstoOther,
q_FA.[CCC's], q_FA.VFG, q_FA.VRT, q_FA.[GQRS CAT], q_FA.ACTION, q_FA.[Work
Element Description], q_FA.Frequency, q_FA.[WES#], q_FA.Source, q_FA.ID,
q_FA.Active
FROM q_FA
WHERE [SaturdayTF]=True
UNION ALL SELECT "Sunday" AS DayOfWeek, q_FA.Fleet_Activity,
q_FA.BinstoOther, q_FA.[CCC's], q_FA.VFG, q_FA.VRT, q_FA.[GQRS CAT],
q_FA.ACTION, q_FA.[Work Element Description], q_FA.Frequency, q_FA.[WES#],
q_FA.Source, q_FA.ID, q_FA.Active
FROM q_FA
WHERE [SundayTF]=True
UNION ALL SELECT "Removed" AS DayOfWeek, q_FA.Fleet_Activity,
q_FA.BinstoOther, q_FA.[CCC's], q_FA.VFG, q_FA.VRT, q_FA.[GQRS CAT],
q_FA.ACTION, q_FA.[Work Element Description], q_FA.Frequency, q_FA.[WES#],
q_FA.Source, q_FA.ID, q_FA.Active
FROM q_FA
WHERE [Active]=False
UNION ALL SELECT "N/A" AS DayOfWeek, q_FA.Fleet_Activity, q_FA.BinstoOther,
q_FA.[CCC's], q_FA.VFG, q_FA.VRT, q_FA.[GQRS CAT], q_FA.ACTION, q_FA.[Work
Element Description], q_FA.Frequency, q_FA.[WES#], q_FA.Source, q_FA.ID,
q_FA.Active
FROM q_FA
WHERE ([SundayTF]=False AND [SaturdayTF]=False AND [MondayTF]=False AND
[TuesdayTF]=False AND [WednesdayTF]=False AND [ThursdayTF]=False AND
[FridayTF]=False);


<<Q_FA>>
SELECT "Duty Cycle" as Fleet_Activity, [QMC MASTER LIST].BinstoOther, [QMC
MASTER LIST].[CCC's], [QMC MASTER LIST].VFG, [QMC MASTER LIST].VRT, [QMC
MASTER LIST].[GQRS CAT], [QMC MASTER LIST].ACTION, [QMC MASTER LIST].[Work
Element Description], [QMC MASTER LIST].Frequency, [QMC MASTER LIST].[WES#],
[QMC MASTER LIST].Source, [QMC MASTER LIST].MondayTF, [QMC MASTER
LIST].TuesdayTF, [QMC MASTER LIST].WednesdayTF, [QMC MASTER LIST].ThursdayTF,
[QMC MASTER LIST].FridayTf, [QMC MASTER LIST].SaturdayTF, [QMC MASTER
LIST].SundayTF, [QMC MASTER LIST].CriticalIssueTF, [QMC MASTER LIST].ID,
[QMC MASTER LIST].Active, [QMC MASTER LIST].[CamoTesting]
FROM [QMC MASTER LIST] where [DutyCycleTF]=True
union all
SELECT "Shakedown" as Fleet_Activity, [QMC MASTER LIST].BinstoOther, [QMC
MASTER LIST].[CCC's], [QMC MASTER LIST].VFG, [QMC MASTER LIST].VRT, [QMC
MASTER LIST].[GQRS CAT], [QMC MASTER LIST].ACTION, [QMC MASTER LIST].[Work
Element Description], [QMC MASTER LIST].Frequency, [QMC MASTER LIST].[WES#],
[QMC MASTER LIST].Source, [QMC MASTER LIST].MondayTF, [QMC MASTER
LIST].TuesdayTF, [QMC MASTER LIST].WednesdayTF, [QMC MASTER LIST].ThursdayTF,
[QMC MASTER LIST].FridayTf, [QMC MASTER LIST].SaturdayTF, [QMC MASTER
LIST].SundayTF, [QMC MASTER LIST].CriticalIssueTF, [QMC MASTER LIST].ID,
[QMC MASTER LIST].Active, [QMC MASTER LIST].[CamoTesting]
FROM [QMC MASTER LIST] where [ShakedownTF]=True
UNION ALL SELECT "Extended" as Fleet_Activity, [QMC MASTER
LIST].BinstoOther, [QMC MASTER LIST].[CCC's], [QMC MASTER LIST].VFG, [QMC
MASTER LIST].VRT, [QMC MASTER LIST].[GQRS CAT], [QMC MASTER LIST].ACTION,
[QMC MASTER LIST].[Work Element Description], [QMC MASTER LIST].Frequency,
[QMC MASTER LIST].[WES#], [QMC MASTER LIST].Source, [QMC MASTER
LIST].MondayTF, [QMC MASTER LIST].TuesdayTF, [QMC MASTER LIST].WednesdayTF,
[QMC MASTER LIST].ThursdayTF, [QMC MASTER LIST].FridayTf, [QMC MASTER
LIST].SaturdayTF, [QMC MASTER LIST].SundayTF, [QMC MASTER
LIST].CriticalIssueTF, [QMC MASTER LIST].ID, [QMC MASTER LIST].Active, [QMC
MASTER LIST].[CamoTesting]
FROM [QMC MASTER LIST] where [ExtendedTF]=True
union all
SELECT "EXT - Hot & Humid" as Fleet_Activity, [QMC MASTER LIST].BinstoOther,
[QMC MASTER LIST].[CCC's], [QMC MASTER LIST].VFG, [QMC MASTER LIST].VRT, [QMC
MASTER LIST].[GQRS CAT], [QMC MASTER LIST].ACTION, [QMC MASTER LIST].[Work
Element Description], [QMC MASTER LIST].Frequency, [QMC MASTER LIST].[WES#],
[QMC MASTER LIST].Source, [QMC MASTER LIST].MondayTF, [QMC MASTER
LIST].TuesdayTF, [QMC MASTER LIST].WednesdayTF, [QMC MASTER LIST].ThursdayTF,
[QMC MASTER LIST].FridayTf, [QMC MASTER LIST].SaturdayTF, [QMC MASTER
LIST].SundayTF, [QMC MASTER LIST].CriticalIssueTF, [QMC MASTER LIST].ID,
[QMC MASTER LIST].Active, [QMC MASTER LIST].[CamoTesting]
FROM [QMC MASTER LIST] where [HotHumidTF]=True
union all
SELECT "EXT - Mountains" as Fleet_Activity, [QMC MASTER LIST].BinstoOther,
[QMC MASTER LIST].[CCC's], [QMC MASTER LIST].VFG, [QMC MASTER LIST].VRT, [QMC
MASTER LIST].[GQRS CAT], [QMC MASTER LIST].ACTION, [QMC MASTER LIST].[Work
Element Description], [QMC MASTER LIST].Frequency, [QMC MASTER LIST].[WES#],
[QMC MASTER LIST].Source, [QMC MASTER LIST].MondayTF, [QMC MASTER
LIST].TuesdayTF, [QMC MASTER LIST].WednesdayTF, [QMC MASTER LIST].ThursdayTF,
[QMC MASTER LIST].FridayTf, [QMC MASTER LIST].SaturdayTF, [QMC MASTER
LIST].SundayTF, [QMC MASTER LIST].CriticalIssueTF, [QMC MASTER LIST].ID,
[QMC MASTER LIST].Active, [QMC MASTER LIST].[CamoTesting]
FROM [QMC MASTER LIST] where [MountainsTF]=True
union all
SELECT "EXT - Hot & Dry" as Fleet_Activity, [QMC MASTER LIST].BinstoOther,
[QMC MASTER LIST].[CCC's], [QMC MASTER LIST].VFG, [QMC MASTER LIST].VRT, [QMC
MASTER LIST].[GQRS CAT], [QMC MASTER LIST].ACTION, [QMC MASTER LIST].[Work
Element Description], [QMC MASTER LIST].Frequency, [QMC MASTER LIST].[WES#],
[QMC MASTER LIST].Source, [QMC MASTER LIST].MondayTF, [QMC MASTER
LIST].TuesdayTF, [QMC MASTER LIST].WednesdayTF, [QMC MASTER LIST].ThursdayTF,
[QMC MASTER LIST].FridayTf, [QMC MASTER LIST].SaturdayTF, [QMC MASTER
LIST].SundayTF, [QMC MASTER LIST].CriticalIssueTF, [QMC MASTER LIST].ID,
[QMC MASTER LIST].Active, [QMC MASTER LIST].[CamoTesting]
FROM [QMC MASTER LIST] where [HotDryTF]=True
union all
SELECT "EXT - Cold" as Fleet_Activity, [QMC MASTER LIST].BinstoOther, [QMC
MASTER LIST].[CCC's], [QMC MASTER LIST].VFG, [QMC MASTER LIST].VRT, [QMC
MASTER LIST].[GQRS CAT], [QMC MASTER LIST].ACTION, [QMC MASTER LIST].[Work
Element Description], [QMC MASTER LIST].Frequency, [QMC MASTER LIST].[WES#],
[QMC MASTER LIST].Source, [QMC MASTER LIST].MondayTF, [QMC MASTER
LIST].TuesdayTF, [QMC MASTER LIST].WednesdayTF, [QMC MASTER LIST].ThursdayTF,
[QMC MASTER LIST].FridayTf, [QMC MASTER LIST].SaturdayTF, [QMC MASTER
LIST].SundayTF, [QMC MASTER LIST].CriticalIssueTF, [QMC MASTER LIST].ID,
[QMC MASTER LIST].Active, [QMC MASTER LIST].[CamoTesting]
FROM [QMC MASTER LIST] where [ColdTF]=True
union all
SELECT "Trailer Tow" as Fleet_Activity, [QMC MASTER LIST].BinstoOther, [QMC
MASTER LIST].[CCC's], [QMC MASTER LIST].VFG, [QMC MASTER LIST].VRT, [QMC
MASTER LIST].[GQRS CAT], [QMC MASTER LIST].ACTION, [QMC MASTER LIST].[Work
Element Description], [QMC MASTER LIST].Frequency, [QMC MASTER LIST].[WES#],
[QMC MASTER LIST].Source, [QMC MASTER LIST].MondayTF, [QMC MASTER
LIST].TuesdayTF, [QMC MASTER LIST].WednesdayTF, [QMC MASTER LIST].ThursdayTF,
[QMC MASTER LIST].FridayTf, [QMC MASTER LIST].SaturdayTF, [QMC MASTER
LIST].SundayTF, [QMC MASTER LIST].CriticalIssueTF, [QMC MASTER LIST].ID,
[QMC MASTER LIST].Active, [QMC MASTER LIST].[CamoTesting]
FROM [QMC MASTER LIST] where [TrailerTowTF]=True
union all
SELECT "Vehicle Prep" as Fleet_Activity, [QMC MASTER LIST].BinstoOther, [QMC
MASTER LIST].[CCC's], [QMC MASTER LIST].VFG, [QMC MASTER LIST].VRT, [QMC
MASTER LIST].[GQRS CAT], [QMC MASTER LIST].ACTION, [QMC MASTER LIST].[Work
Element Description], [QMC MASTER LIST].Frequency, [QMC MASTER LIST].[WES#],
[QMC MASTER LIST].Source, [QMC MASTER LIST].MondayTF, [QMC MASTER
LIST].TuesdayTF, [QMC MASTER LIST].WednesdayTF, [QMC MASTER LIST].ThursdayTF,
[QMC MASTER LIST].FridayTf, [QMC MASTER LIST].SaturdayTF, [QMC MASTER
LIST].SundayTF, [QMC MASTER LIST].CriticalIssueTF, [QMC MASTER LIST].ID,
[QMC MASTER LIST].Active, [QMC MASTER LIST].[CamoTesting]
FROM [QMC MASTER LIST] where [VehiclePrepTF]=True
union all
SELECT "4x4 Off Road" as Fleet_Activity, [QMC MASTER LIST].BinstoOther, [QMC
MASTER LIST].[CCC's], [QMC MASTER LIST].VFG, [QMC MASTER LIST].VRT, [QMC
MASTER LIST].[GQRS CAT], [QMC MASTER LIST].ACTION, [QMC MASTER LIST].[Work
Element Description], [QMC MASTER LIST].Frequency, [QMC MASTER LIST].[WES#],
[QMC MASTER LIST].Source, [QMC MASTER LIST].MondayTF, [QMC MASTER
LIST].TuesdayTF, [QMC MASTER LIST].WednesdayTF, [QMC MASTER LIST].ThursdayTF,
[QMC MASTER LIST].FridayTf, [QMC MASTER LIST].SaturdayTF, [QMC MASTER
LIST].SundayTF, [QMC MASTER LIST].CriticalIssueTF, [QMC MASTER LIST].ID,
[QMC MASTER LIST].Active, [QMC MASTER LIST].[CamoTesting]
FROM [QMC MASTER LIST] where [4x4OffRoadTF]=True
UNION ALL
SELECT "Pre-Drive Checklist" as Fleet_Activity, [QMC MASTER
LIST].BinstoOther, [QMC MASTER LIST].[CCC's], [QMC MASTER LIST].VFG, [QMC
MASTER LIST].VRT, [QMC MASTER LIST].[GQRS CAT], [QMC MASTER LIST].ACTION,
[QMC MASTER LIST].[Work Element Description], [QMC MASTER LIST].Frequency,
[QMC MASTER LIST].[WES#], [QMC MASTER LIST].Source, [QMC MASTER
LIST].MondayTF, [QMC MASTER LIST].TuesdayTF, [QMC MASTER LIST].WednesdayTF,
[QMC MASTER LIST].ThursdayTF, [QMC MASTER LIST].FridayTf, [QMC MASTER
LIST].SaturdayTF, [QMC MASTER LIST].SundayTF, [QMC MASTER
LIST].CriticalIssueTF, [QMC MASTER LIST].ID, [QMC MASTER LIST].Active, [QMC
MASTER LIST].[CamoTesting]
FROM [QMC MASTER LIST] where [PDITF]=True
UNION ALL SELECT "High Mileage" as Fleet_Activity, [QMC MASTER
LIST].BinstoOther, [QMC MASTER LIST].[CCC's], [QMC MASTER LIST].VFG, [QMC
MASTER LIST].VRT, [QMC MASTER LIST].[GQRS CAT], [QMC MASTER LIST].ACTION,
[QMC MASTER LIST].[Work Element Description], [QMC MASTER LIST].Frequency,
[QMC MASTER LIST].[WES#], [QMC MASTER LIST].Source, [QMC MASTER
LIST].MondayTF, [QMC MASTER LIST].TuesdayTF, [QMC MASTER LIST].WednesdayTF,
[QMC MASTER LIST].ThursdayTF, [QMC MASTER LIST].FridayTf, [QMC MASTER
LIST].SaturdayTF, [QMC MASTER LIST].SundayTF, [QMC MASTER
LIST].CriticalIssueTF, [QMC MASTER LIST].ID, [QMC MASTER LIST].Active, [QMC
MASTER LIST].[CamoTesting]
FROM [QMC MASTER LIST] where [HighMileageTF]=True
UNION ALL SELECT "Observation Training" as Fleet_Activity, [QMC MASTER
LIST].BinstoOther, [QMC MASTER LIST].[CCC's], [QMC MASTER LIST].VFG, [QMC
MASTER LIST].VRT, [QMC MASTER LIST].[GQRS CAT], [QMC MASTER LIST].ACTION,
[QMC MASTER LIST].[Work Element Description], [QMC MASTER LIST].Frequency,
[QMC MASTER LIST].[WES#], [QMC MASTER LIST].Source, [QMC MASTER
LIST].MondayTF, [QMC MASTER LIST].TuesdayTF, [QMC MASTER LIST].WednesdayTF,
[QMC MASTER LIST].ThursdayTF, [QMC MASTER LIST].FridayTf, [QMC MASTER
LIST].SaturdayTF, [QMC MASTER LIST].SundayTF, [QMC MASTER
LIST].CriticalIssueTF, [QMC MASTER LIST].ID, [QMC MASTER LIST].Active, [QMC
MASTER LIST].[CamoTesting]
FROM [QMC MASTER LIST] where [ACTION]="Observe"
UNION ALL SELECT "Removed" as Fleet_Activity, [QMC MASTER LIST].BinstoOther,
[QMC MASTER LIST].[CCC's], [QMC MASTER LIST].VFG, [QMC MASTER LIST].VRT, [QMC
MASTER LIST].[GQRS CAT], [QMC MASTER LIST].ACTION, [QMC MASTER LIST].[Work
Element Description], [QMC MASTER LIST].Frequency, [QMC MASTER LIST].[WES#],
[QMC MASTER LIST].Source, [QMC MASTER LIST].MondayTF, [QMC MASTER
LIST].TuesdayTF, [QMC MASTER LIST].WednesdayTF, [QMC MASTER LIST].ThursdayTF,
[QMC MASTER LIST].FridayTf, [QMC MASTER LIST].SaturdayTF, [QMC MASTER
LIST].SundayTF, [QMC MASTER LIST].CriticalIssueTF, [QMC MASTER LIST].ID,
[QMC MASTER LIST].Active, [QMC MASTER LIST].[CamoTesting]
FROM [QMC MASTER LIST] where [Active]=False
UNION ALL SELECT "Pre-Camo Inspection" as Fleet_Activity, [QMC MASTER
LIST].BinstoOther, [QMC MASTER LIST].[CCC's], [QMC MASTER LIST].VFG, [QMC
MASTER LIST].VRT, [QMC MASTER LIST].[GQRS CAT], [QMC MASTER LIST].ACTION,
[QMC MASTER LIST].[Work Element Description], [QMC MASTER LIST].Frequency,
[QMC MASTER LIST].[WES#], [QMC MASTER LIST].Source, [QMC MASTER
LIST].MondayTF, [QMC MASTER LIST].TuesdayTF, [QMC MASTER LIST].WednesdayTF,
[QMC MASTER LIST].ThursdayTF, [QMC MASTER LIST].FridayTf, [QMC MASTER
LIST].SaturdayTF, [QMC MASTER LIST].SundayTF, [QMC MASTER
LIST].CriticalIssueTF, [QMC MASTER LIST].ID, [QMC MASTER LIST].Active, [QMC
MASTER LIST].[CamoTesting]
FROM [QMC MASTER LIST] where [CamoTesting]=True
UNION ALL SELECT "Overnight" as Fleet_Activity, [QMC MASTER
LIST].BinstoOther, [QMC MASTER LIST].[CCC's], [QMC MASTER LIST].VFG, [QMC
MASTER LIST].VRT, [QMC MASTER LIST].[GQRS CAT], [QMC MASTER LIST].ACTION,
[QMC MASTER LIST].[Work Element Description], [QMC MASTER LIST].Frequency,
[QMC MASTER LIST].[WES#], [QMC MASTER LIST].Source, [QMC MASTER
LIST].MondayTF, [QMC MASTER LIST].TuesdayTF, [QMC MASTER LIST].WednesdayTF,
[QMC MASTER LIST].ThursdayTF, [QMC MASTER LIST].FridayTf, [QMC MASTER
LIST].SaturdayTF, [QMC MASTER LIST].SundayTF, [QMC MASTER
LIST].CriticalIssueTF, [QMC MASTER LIST].ID, [QMC MASTER LIST].Active, [QMC
MASTER LIST].[CamoTesting]
FROM [QMC MASTER LIST] where [OvernightTF]=True
UNION ALL SELECT "Service" as Fleet_Activity, [QMC MASTER LIST].BinstoOther,
[QMC MASTER LIST].[CCC's], [QMC MASTER LIST].VFG, [QMC MASTER LIST].VRT, [QMC
MASTER LIST].[GQRS CAT], [QMC MASTER LIST].ACTION, [QMC MASTER LIST].[Work
Element Description], [QMC MASTER LIST].Frequency, [QMC MASTER LIST].[WES#],
[QMC MASTER LIST].Source, [QMC MASTER LIST].MondayTF, [QMC MASTER
LIST].TuesdayTF, [QMC MASTER LIST].WednesdayTF, [QMC MASTER LIST].ThursdayTF,
[QMC MASTER LIST].FridayTf, [QMC MASTER LIST].SaturdayTF, [QMC MASTER
LIST].SundayTF, [QMC MASTER LIST].CriticalIssueTF, [QMC MASTER LIST].ID,
[QMC MASTER LIST].Active, [QMC MASTER LIST].[CamoTesting]
FROM [QMC MASTER LIST] where [ServiceTF]=True;
Click to expand...
Click to expand...
 
Back
Top