Forming Access Query!

[Shubham Aggarwal]

Hey, before I post my query, I need to mention that I am new to access and have no knowledge of SQL. So, will be highly thankful if i get guided answers. I know fundamentals of Access.

I have a table with have data like:



ID Inv No. Quality Kgs Invoice Amount
1 101 A Grade 500
2 101 C Grade 700
3 102 A Grade 800
4 109 B Grade 560
5 109 C Grade 740
6 109 A Grade 600




Now I want to make a query to show rows (ID 1,3,4). Basically, my criteria is first row of particular set of Invoice No. to fill in Invoice Amount.


Kindly advice.

Thanks in advance!

[pbaldy]

Sound like this would work:

http://www.baldyweb.com/LastValue.htm

[June7]

Or maybe this: http://allenbrowne.com/subquery-01.html#TopN