By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,203 Members | 1,392 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,203 IT Pros & Developers. It's quick & easy.

Re: Finding Latest 'Event' for a Person from an Event table

P: n/a
On Jul 28, 10:29 am, "Steve" <nonse...@nomsense.comwrote:
The latest EDate would be the max EDate.
Make a copy of your query. Remove the Top property in the query and set
sorting to no sort. Click on the Sigma (looks like capital E) button in the
menu at the top of the screen. Under EDate, change GroupBy to Max. Run the
query and see if that gives you what you want.

Steve
That's brilliant Steve. Thank you very much.

Regards David

Jul 28 '08 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.