Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Docmd.openreport order by

Status
Not open for further replies.

eatwork

Technical User
May 16, 2005
155
CA
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.
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top