Problem creating a report

[artur]

Imagine a table with the information like shown below:

TABLE "A":

DATA1 DATA2
------------------------
A1 B1
A1 B2
A1 B3
A2 B2
A2 B4
A3 B1
A3 B2
A3 B4

I want to create a report with the next information:
DATA1 DATA2
------------------------
A1 B1
A2 B2
A3 B1

It is, only the first row of each distinct DATA1. Can anyone help me on SQL or MS Access design??

Thanks once again!

 

[Dennisk]

use a total query and group by Data1 and first of Data2