By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,869 Members | 1,639 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,869 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.

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.