Jump to content

jalexm

Members
  • Posts

    2
  • Joined

  • Last visited

jalexm's Achievements

Newbie

Newbie (1/7)

0

Reputation

  1. Hello, I have a table similar to this: Table: Sectors Sector Type -------------- A X B X A Y C Z A X B Z And I need to build a query so that I get these results: Sector Nr of X Nr of Y Nr of Z -------------------------------------------- A 2 1 0 B 1 0 1 C 0 0 1 Does anyone know how to get this? Note: using an old MS-Access version (2003). Thanks.
  2. Hello,I have a table Tab1:Name Year Value-----------------------John 2010 1000Charles 2008 500Charles 2001 800John 2003 600Mary 2012 2500And need to get the following results:Name Year Value-----------------------Charles 2008 500John 2010 1000Mary 2012 2500As you can see, for each name I need to get the last record of the year.Does anyone know how to get this?Note: using MS-Access. Thanks.
×
×
  • Create New...