count total and keep desc order

[eugz]

Hi All
I ceated simple query that sorted in desc order SvcDate. And created report besed on that querty with count total record like ="Total " & Count([CountField]) & " Patient(s)" in report footer. Without count field the report in desc order when I incude count field I'm loosing order. What is problem?

Thanks.

 

[PNGBill]

Try entering the sort order on the Report Order by Property.

Type Svcdate desc

 

[PNGBill]

If you are using Grouping in your report, you also set sort order there.

 

[eugz]

Hi PNGBill
Thanks for help. It is works.