Filter query with these filters

[Crocdundee]

Using Access 2007

There are the columns needed but I do not know how to put the code below in a SQL code
Select these Columns or fields as they are called

Select Track,Rcno,Horse,Tabno,Nr,APrice
where Rcdate = [Forms]![Form2]![Combo0]
and Trckid is distinct
and Aprice is Min Value

Data for Rcdate is not required Visible
Data for Trckid is not required visible
But must be used for the filter
So what I am saying to the query is I wish to see all records in APrice where Rcdate = [Forms]![Form2]![Combo0]
and Trckid is distinct
with the columns from the first line

Hope someone can please help me
Graham

 

[SydneyGeek]

Hi Graham, build the query like this:

Add all the fields to the grid in the order that you want to see them.
In the Criteria row for RcDate, put [Forms]![Form2]![Combo0]
You don't need TrckID because the Track name should be equivalent.
Now, still in Design view, click the big Sigma item to make this a Totals query. You will see a new Totals row, with Group By as the default value.
Change Aprice to Min, and run the query.

Denis