jalexm

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.

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.