How to filter query in Design view

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Eric - 31 May 2008 17:41 GMT

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-

Reply to this Message

Wolfgang Kais - 31 May 2008 22:52 GMT

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
[quoted text clipped - 10 lines]
> 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".

Signature

Regards,
Wolfgang

Reply to this Message