[AccessD] Access 2007 Reports

Run the data into a temp table and use that for the reporting.
Then, you can take the sorts off of it completely and only do
the grouping. Delete the data out fo the temp table on close
of the report.


At 06:42 PM 10/6/2009, you wrote:
>Date: Tue, 6 Oct 2009 10:04:03 -0700 (PDT)
>From: Dale Kalsow <dkalsow at yahoo.com>
>Subject: [AccessD] Access 2007 Reports
>To: Access Developers discussion and problem solving
>         <accessd at databaseadvisors.com>
>Message-ID: <948028.35822.qm at web50405.mail.re2.yahoo.com>
>Content-Type: text/plain; charset=iso-8859-1
>
>
>I was wondering if anyone had any words of wisdom for me.
>?
>I have an Access 2007 report with two sorts and then one Group 
>Break.? Currently the groupbreak is not working - it is breaking on 
>everything even though the data is correct (I have verifed it by printing it).?
>?
>If I take out the second sort the groupbreaking works fine but as 
>soon as I add it back in the report runs incorrect again.
>?
>Does any one know what to look for?? When I exclude the second sort 
>that data is on not sorted correctly so the only other option that I 
>see would be bring the two sorts together into one field in the report query.
>?
>thanks!
>?
>Dale