Search results

  1. A

    Transposing Data in Access?

    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...
  2. A

    Ranking Groups in Access

    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
  3. A

    Counting Consecutive Months in Access

    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...
Back
Top Bottom