I have a table storing tardy data. The fields are userid, date, tardymins
and Supid. How can i write a query to sum the tardymins for each userid that
have the same supid within a date range? My code below doesn`t seem work.
Select Userid, sum(Tardymins) as [Totaltardys], Supid, Date
From Tardys
Where Supid Like ‘a2a’
And Date Between #1/01/01# And #1/31/01# .
Thanks in advance.