S
Steven Phillips via AccessMonster.com
Please HELP!!
I am running an efficiency query for employees and need to capture data
entered into a table between specified dates. I only enter a date for each
record entered in the table. My SQL is below, thanks in advance.
SELECT Personell.Supervisor, Personell.[ID#], Avg([Total Production
Efficiencies Query].[Production Efficiencies]) AS [AvgOfProduction
Efficiencies], Avg([Total Setup Efficiencies Query].[Setup Efficiencies])
AS [AvgOfSetup Efficiencies], [INPUT Daily Grinding Data].Date
FROM (([INPUT Daily Grinding Data] INNER JOIN Personell ON [INPUT Daily
Grinding Data].[ID#] = Personell.[ID#]) INNER JOIN [Total Production
Efficiencies Query] ON Personell.[ID#] = [Total Production Efficiencies
Query].[ID#]) INNER JOIN [Total Setup Efficiencies Query] ON Personell.
[ID#] = [Total Setup Efficiencies Query].[ID#]
GROUP BY Personell.Supervisor, Personell.[ID#], [INPUT Daily Grinding Data]
..Date
HAVING (((Personell.Supervisor)="Phillips") AND (([INPUT Daily Grinding
Data].Date) Is Not Null And ([INPUT Daily Grinding Data].Date) Between
[forms]![Input Daily Grinding Data]![start date] And [forms]![Input Daily
Grinding Data]![end date]));
I am running an efficiency query for employees and need to capture data
entered into a table between specified dates. I only enter a date for each
record entered in the table. My SQL is below, thanks in advance.
SELECT Personell.Supervisor, Personell.[ID#], Avg([Total Production
Efficiencies Query].[Production Efficiencies]) AS [AvgOfProduction
Efficiencies], Avg([Total Setup Efficiencies Query].[Setup Efficiencies])
AS [AvgOfSetup Efficiencies], [INPUT Daily Grinding Data].Date
FROM (([INPUT Daily Grinding Data] INNER JOIN Personell ON [INPUT Daily
Grinding Data].[ID#] = Personell.[ID#]) INNER JOIN [Total Production
Efficiencies Query] ON Personell.[ID#] = [Total Production Efficiencies
Query].[ID#]) INNER JOIN [Total Setup Efficiencies Query] ON Personell.
[ID#] = [Total Setup Efficiencies Query].[ID#]
GROUP BY Personell.Supervisor, Personell.[ID#], [INPUT Daily Grinding Data]
..Date
HAVING (((Personell.Supervisor)="Phillips") AND (([INPUT Daily Grinding
Data].Date) Is Not Null And ([INPUT Daily Grinding Data].Date) Between
[forms]![Input Daily Grinding Data]![start date] And [forms]![Input Daily
Grinding Data]![end date]));