[AccessD] Access 2007 Reports

I haven't had the need to create such a report in Access 2007, but my
initial suggestion would be to create a toy report with two sorts and a
group break and if it doesn't work right, suspect a bug. If that is the
case, then I would suggest adding a calculated column that concatenates your
two sorts into one column, and then sort on that. Just a thought.
Arthur

On Tue, Oct 6, 2009 at 5:28 PM, Stuart McLachlan <stuart at lexacorp.com.pg>wrote:

> Hard to tell.  How about posting the recordsource and the names of the sort
> and group break
> fields?
>
> --
> Stuart
>
>
> On 6 Oct 2009 at 10:04, Dale Kalsow wrote:
>
> >
> > 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
> >
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>