Hi,
I am new to this forum and I know this is probably a simple question but, I have a query set up to get data from a table I created and have been able to run reports based on the query. What I need is to be able to use this same query and get all the data for a week or a month at a time. Any ideas? Here is the SQL from the query I have:
SELECT [JOB CODE ENTRY].DATE, [JOB CODE ENTRY].[USER ID], [JOB CODE ENTRY].DEPT, [JOB CODE ENTRY].[TOTAL TIME], [JOB CODE ENTRY].[JOB CODE], [JOB CODE ENTRY].UNITS, [JOB CODES].[STD CODE], [JOB CODES].[UNITS PER HOUR], [JOB CODE ENTRY]![TOTAL TIME]*[JOB CODES]![UNITS PER HOUR] AS [TOTAL EXPECTED], [UNITS]/[TOTAL EXPECTED] AS [%], [EmployeeLastName] & " " & (Left([EmployeeFirstName],1)) AS NAME, [JOB CODES].DESCRIPTION
FROM ([JOB CODE ENTRY] INNER JOIN [JOB CODES] ON [JOB CODE ENTRY].[JOB CODE] = [JOB CODES].[JOB CODE]) INNER JOIN [SHORT ID FOR JOB CODE ENTRY] ON [JOB CODE ENTRY].[USER ID] = [SHORT ID FOR JOB CODE ENTRY].[SHORT ID]
WHERE ((([JOB CODE ENTRY].DATE)=[Enter Date]));
I am new to this forum and I know this is probably a simple question but, I have a query set up to get data from a table I created and have been able to run reports based on the query. What I need is to be able to use this same query and get all the data for a week or a month at a time. Any ideas? Here is the SQL from the query I have:
SELECT [JOB CODE ENTRY].DATE, [JOB CODE ENTRY].[USER ID], [JOB CODE ENTRY].DEPT, [JOB CODE ENTRY].[TOTAL TIME], [JOB CODE ENTRY].[JOB CODE], [JOB CODE ENTRY].UNITS, [JOB CODES].[STD CODE], [JOB CODES].[UNITS PER HOUR], [JOB CODE ENTRY]![TOTAL TIME]*[JOB CODES]![UNITS PER HOUR] AS [TOTAL EXPECTED], [UNITS]/[TOTAL EXPECTED] AS [%], [EmployeeLastName] & " " & (Left([EmployeeFirstName],1)) AS NAME, [JOB CODES].DESCRIPTION
FROM ([JOB CODE ENTRY] INNER JOIN [JOB CODES] ON [JOB CODE ENTRY].[JOB CODE] = [JOB CODES].[JOB CODE]) INNER JOIN [SHORT ID FOR JOB CODE ENTRY] ON [JOB CODE ENTRY].[USER ID] = [SHORT ID FOR JOB CODE ENTRY].[SHORT ID]
WHERE ((([JOB CODE ENTRY].DATE)=[Enter Date]));