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
