Returning a value single value from several records

[Wrecker]

I track performance by day. I have several records (7 or 8) in field for a given day, with the same value (a persons name). When I run a query that sums the data by date, I also need a field to return the "name of the person" who's is in those 7 or 8 records before the data us summed.

Is there a command or expression that will do this?


Hope I'm making sence.......

Thanks in advance
Paul

 

[MichaelRed]

Generically, this is a Domain Aggregate query. Use a Group By in the same row where the COunt (or Sum?) is, place it in the "UserName" column.

MichaelRed
mred@att.net

There is never time to do it right but there is always time to do it over