Search results
-
G
Problems with [Group by] in SQL
The problem is not with the dates, it's with the GROUP BY - Access is giving me an 3122 error: "You tried to execute a query that does not include the specified expression a_date as part of an aggregate function. (Error 3122)" Sorry, propably should've mentioned this earlier, but it has... -
G
Problems with [Group by] in SQL
Hey, I've got a tableA, that looks like this: worker_id (number) part (text) a_date (date/time) time_start (date/time) time_end (date/time) bad_qty (number) qty (number) bad_percent (number) total_time (number) efficiency (number) Some data: 294 PART A 2009-08-12 07:40:00 14:25:00 1 295 0,34...