Ascending order problem

[Groundrush]

I have a query that when run should return all records in ascending order (by Property Name),which works fine, but I need those records to be in (date order) as well.

When I sort both fields to ascending order in the same query
the records return ok, but the dates are jumbled.

any Ideas? thanks

 

[simongallop]

The order in which they are sorted is by the furthest left of your fields. So if you want to group by date and then within the date you want to sort by customer if customer is ColumnA and date is ColumnB you would need to create ColumnC as customer and you would sort on that, so that date is your leftmost sorting field.

HTH

 

[Groundrush]

Maybe 2 qry's required

I need it to be in (Property Name) order and within that in (date) order.

I think perhaps I need to run 2 queries one for Property and then one for date

Thanks

 

[Groundrush]

Thanks Pat

the qry works ok now, but I cant seem to return the records in the correct order when I activate the qry from a form

The qry is the record source for the form and I have a "find record command button" to which you type in the Property that you are looking for, but there are still some records that end up in the wrong date order.

any ideas why this is?