Docmd.openreport order by

[eatwork]

Hi I was wondering if there is a way to order the data shown in a report when I open the report. I know I can filter the data in a report, but the users require the report to order the data based on their selected criteria.

eg.
DoCmd.OpenReport stDocName, acPreview, , "Order by dDate"

does not seem to work, gives an error.

Thank you.

 

[eatwork]

OH forgot:
1) Database: MS Access 2003
2) Report: MS Access Report
3) Bound: Yes, the report is bound to a query within the database

 

[eatwork]

Hi,
I was able to solve the problem after some more searching on the the topic. Thanks for the help everyone.
check out for the solution to this problem:

http://groups.google.ca/group/microsoft.public.access.reports/

browse_thread/thread/4283a736355703f7/
d934783b0af20841%23d934783b0af20841