How to set order with designated column

[ckleung]

Hi, I create an inventory report which source is from a query. I have set a field "Date" displaying in ascending order in query. But the report cannot achieve that result.
My code is:
Private Sub PrtDelRec_Click()
DoCmd.OpenReport "DeletionTransferRpt", acViewPreview
End sub

Can anyone help? Thanks in advance.

 

[SOS]

In your report just use the Grouping and Sorting to set the sort (unless you need it dynamic). Reports do not use the sorting form queries. You have to set it explicitly in the Grouping and Sorting.

 

[ckleung]

Thanks, SOS, can you teach me how to write the code?

 

[Mihail]

It is not about the code.
This is done in Raport Design View.
How it is done ?
That depend of your Access version.

 

[ckleung]

Hi, Mihail and SOS, Thanks for your advice. The problem has been solved. Thanks again.