Avatar of vbnetcoder
vbnetcoder

asked on 

order by in my report

I am using  a query for a recordset for a report and it orders correctly.  However, when i run the report it does not.  Why?

What it does seem to order on is the field unique id
Microsoft Access

Avatar of undefined
Last Comment
Jim Dettman (EE MVE)
ASKER CERTIFIED SOLUTION
Avatar of IrogSinta
IrogSinta
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of vbnetcoder
vbnetcoder

ASKER

ty
Just to add a bit, the reason for that is that in order for the report engine to offer things like groups and performing calculations over a group or the report, it needs to be aware of the ordering in the data, which if done in the query, it would not know.

So anything specified in terms of ordering in the record source is ignored. The report applies it's own ordering as specified in the report.

So you should be using a query that does not order any of the fields.  If you are, then your doing extra work.

Jim.
Microsoft Access
Microsoft Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo