How to show fund with most current performance

**AAE** · April 9th, 2009, 01:53 PM posted to microsoft.public.access.queries

Please help. I am trying to run a query from a table with fund names and
monthly performance for each fund. Each fund has a unique ID number. I only
want to see the most current month for each unique ID number. How do I show
only the most current month for each fund? Thanks!

**NoÃ«lla GabriÃ«l** · April 9th, 2009, 02:09 PM posted to microsoft.public.access.queries

Hi,

you can make a groupsquery (totals button) group by fundID and if the table
has one line per month take the max value of the field which stores the month.

--
Kind regards
NoÃ«lla

"AAE" wrote:

Please help. I am trying to run a query from a table with fund names and
monthly performance for each fund. Each fund has a unique ID number. I only
want to see the most current month for each unique ID number. How do I show
only the most current month for each fund? Thanks!

**AAE** · April 9th, 2009, 02:22 PM posted to microsoft.public.access.queries

Thanks NoÃ«lla, can't believe how easy that was!

Regards,

Alan

"NoÃ«lla GabriÃ«l" wrote:

Hi,

you can make a groupsquery (totals button) group by fundID and if the table
has one line per month take the max value of the field which stores the month.

--
Kind regards
NoÃ«lla

"AAE" wrote:

Please help. I am trying to run a query from a table with fund names and
monthly performance for each fund. Each fund has a unique ID number. I only
want to see the most current month for each unique ID number. How do I show
only the most current month for each fund? Thanks!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode