Ver Mensaje Individual
  #1 (permalink)  
Antiguo 07/10/2010, 07:04
josedb
 
Fecha de Ingreso: octubre-2010
Mensajes: 1
Antigüedad: 14 años, 5 meses
Puntos: 0
Pregunta Query en Access

Buenos dias tengo una base de datos en Access 2003 y tengo la siguiente tabla
100 1 $183,000.00 $2,135.00 $2,637.09 $0.00 $0.00 $0.00
100 2 $182,697.91 $2,131.48 $2,637.09 $0.00 $0.00 $0.00
100 3 $182,392.30 $2,127.91 $2,637.09 $0.00 $0.00 $0.00
100 4 $182,083.13 $2,124.30 $2,637.09 $0.00 $0.00 $0.00
100 5 $181,770.34 $2,120.65 $2,637.09 $0.00 $0.00 $0.00
100 6 $181,453.91 $2,116.96 $2,637.09 $0.00 $0.00 $0.00
100 7 $181,133.78 $2,113.23 $2,637.09 $0.00 $0.00 $0.00
100 8 $180,809.94 $2,109.45 $2,637.09 $0.00 $0.00 $0.00
100 9 $180,482.30 $2,105.63 $2,637.09 $0.00 $0.00 $0.00
100 10 $180,150.83 $2,101.76 $2,637.09 $0.00 $0.00 $0.00
200 1 $300,000.00 $4,000.00 $5,225.39 $0.00 $0.00 $0.00
200 2 $298,974.63 $3,986.33 $5,225.39 $0.00 $0.00 $0.00
200 3 $297,935.53 $3,972.47 $5,225.39 $0.00 $0.00 $0.00
200 4 $296,882.63 $3,958.43 $5,225.39 $0.00 $0.00 $0.00
200 5 $295,815.66 $3,944.21 $5,225.39 $0.00 $0.00 $0.00
200 6 $294,734.47 $3,929.79 $5,225.39 $0.00 $0.00 $0.00

Quiero saber si hay forma de hacer un query que me devuelva el primer registro de cada folio (El Folio es el primer registro 100, 200)
El resultado que necesito es :
100 1 $183,000.00 $2,135.00 $2,637.09 $0.00 $0.00 $0.00
200 1 $300,000.00 $4,000.00 $5,225.39 $0.00 $0.00 $0.00