query result

[chandrashekar b s]

sir/medam,
i have created database
in query suppose query result may be as follows
R. No. qty1 qty2 date
4 500 100 01\dec\03
4 200 500 30\nov\03
3 600 200 30\nov\03
3 500 700 26\nov\03
3 800 900 10\nov\03
2 900 500 01\nov\03
2 600 100 05\nov\03

now i want to select only 1 record(top) of each r no.
records that is as follows
R. No. qty1 qty2 date
4 500 100 01\dec\03
3 600 200 30\nov\03
2 900 500 01\nov\03
what i have to do for gettting this query result
please help me
kindly send me solution to my e-mail
my email id is
(e-mail address removed)

 

[Nikos Yannacopoulos]

In your query design screen, press the button with the
greek Sigma (Summation sign) on the toolba. This will make
your query a Totals query. You will notice that all your
fields will now have a new line in the grid
called "Totas:", and the default value is "Group by".
Change this to "First" for field R.No.
You might want to experiment with Totals queries a bit to
familiarize with them... they are very useful!

HTH,
Nikos