Im pretty new to access and databases in general and I dont really know what I'm doing. I have a database that will track peoples punch in and out times for a warehouse and im trying to make a query that brings up the information for the latest set of entries (ie: The previous days). However when I run it it gives me multiple values for each persons alias when there should only be one. I dont know how I can stick the query into here except in SQL mode, hopefully I just need to tweak my query:
SELECT DISTINCTROW Performance.Score, Max(Performance.Date) AS [Most Recent Date], [Warehouse Info].Hours, [Warehouse Info].Alias, Performance.Hours
FROM Calculations, Performance, [Warehouse Info]
WHERE ((([Warehouse Info].Alias)=[Performance].[ID] And ([Warehouse Info].Alias)=[Warehouse Info].[Alias]))
GROUP BY Performance.Score, [Warehouse Info].Hours, [Warehouse Info].Alias, Performance.Hours;
SELECT DISTINCTROW Performance.Score, Max(Performance.Date) AS [Most Recent Date], [Warehouse Info].Hours, [Warehouse Info].Alias, Performance.Hours
FROM Calculations, Performance, [Warehouse Info]
WHERE ((([Warehouse Info].Alias)=[Performance].[ID] And ([Warehouse Info].Alias)=[Warehouse Info].[Alias]))
GROUP BY Performance.Score, [Warehouse Info].Hours, [Warehouse Info].Alias, Performance.Hours;
Last edited: