needmoremoney
Technical User
I have a query to filter a from a few tables like the below
Datetime Company Id Person
04/04/06 1:00:00PM 123 34 Emily
04/05/06 9:00:00PM 123 34 Emily
04/05/06 2:00:00PM 123 34 Emily
04/05/06 3:00:00PM 322 34 Emily
04/05/06 3:20:00PM 322 34 Emily
04/06/06 2:20:00PM 212 12 John
04/06/06 3:19:00PM 212 12 John
04/08/06 2:11:00PM 565 12 John
04/05/06 3:54:00PM 565 12 John
I would like it like this.
Datetime Company Id Person
04/05/06 9:00:00PM 123 34 Emily
04/05/06 3:20:00PM 322 34 Emily
04/06/06 3:19:00PM 212 12 John
04/05/06 3:54:00PM 565 12 John
I need to have the query pull the largest date and time for each company. Let me know if you have any ideas.
thanks
Datetime Company Id Person
04/04/06 1:00:00PM 123 34 Emily
04/05/06 9:00:00PM 123 34 Emily
04/05/06 2:00:00PM 123 34 Emily
04/05/06 3:00:00PM 322 34 Emily
04/05/06 3:20:00PM 322 34 Emily
04/06/06 2:20:00PM 212 12 John
04/06/06 3:19:00PM 212 12 John
04/08/06 2:11:00PM 565 12 John
04/05/06 3:54:00PM 565 12 John
I would like it like this.
Datetime Company Id Person
04/05/06 9:00:00PM 123 34 Emily
04/05/06 3:20:00PM 322 34 Emily
04/06/06 3:19:00PM 212 12 John
04/05/06 3:54:00PM 565 12 John
I need to have the query pull the largest date and time for each company. Let me know if you have any ideas.
thanks