Recent content by alsamren

Amazing. Thanks!!!

Hi All, I am stuck on a query. I have a query that is feeding off another table. The query lists "Code" as one heading and "Support" as another: code support abc Jennifer abc Mark cde Jeff fgh Thomas ijk Chad ijk Ed As you...

Hi All, I have a table with the following fields: IAKey (Unique key per individual) HouseholdID (Unique key per customer for each IA) Assets (per customer) $ I'm trying to pull the top 10 assets (in terms of value) per IAkey. Is there a query that pulls this? Thanks

I just tried your revised code and it worked for everyone this time. Thanks again!!:)

Oh....and yes, the dates are all for the first of the month. :)

Hi ByteMyzer, So I spoke too soon it seems. It works for many of the people in my list, but it doesn't capture everyone. I have 18,000+ records going back about 72 months. For some reason it's only capturing 574 people out of a total of 1052 people. I'm actually using a unique key instead...

Thanks SO much. I just tried your code ByteMyzer and it worked perfectly! :)

Anyone??? Please Help!

I am looking for the most recent consecutive months. Thanks!

I am trying to write a query to count consecutive months in access. For example, In the following list, I would like to have a value returned as "4" for the number of consecutive months that john doe has appeared on the list. john doe 10/1/2008 john doe 9/1/2008 john doe 8/1/2008 john doe...