How to filter query in Design view

[Eric]

I am only weeks into learning Access '03 and need some help. I have 2 columns
of info. I'm pulling all MODEL's and their COST into a data sheet. In my
query result, if any duplicate 'MODEL's are found, I only then need the data
sheet to show the MODEL with the highest COST. I am just not having any luck
with building a working criteria equation; I would love someone to point out
a specific resource that speaks to this, instead of the exact working answer,
but an answer will work as well.
Example;
MODULE....................COST
0618834028.............15
0618832998.............12<----- I only need this on the Datasheet
0618832998.............11.49 <-- I don't need this one.
0131963163.............14

Thanks in Advance
-Eric-

 

[Wolfgang Kais]

Hello Eric.

I am only weeks into learning Access '03 and need some help. I have
2 columns of info. I'm pulling all MODEL's and their COST into a
data sheet. In my query result, if any duplicate 'MODEL's are found,
I only then need the data sheet to show the MODEL with the highest
COST. I am just not having any luck with building a working criteria
equation; I would love someone to point out a specific resource that
speaks to this, instead of the exact working answer, but an answer
will work as well.
Example;
MODULE....................COST
0618834028.............15
0618832998.............12<----- I only need this on the Datasheet
0618832998.............11.49 <-- I don't need this one.
0131963163.............14

Normally, you wouldn't use criteria for such a query.
Create a query that returns both columns. The, in the view menu, click
"Functions". This will show an additional line in the design grid,
"Grouping" will be pre-selected for moth columns. This is fine for the
MODULE column, but for the COST column, you should select "Maximum".