Prev: Rotate Label on Report
Next: Using filtered form data as record source for report
From: Dragon on 12 Apr 2010 15:46
I have a query that is set up to display records ordered by plan date then by
start date.
When I use the query in a report, it doesn't appear to sort the records.
Is there a way to make the report format the results the same as the query?

Thanks,
Dragon
From: Duane Hookom on 12 Apr 2010 15:53
Reports should always be sorted using the Sorting and Grouping dialog in
Report Design. The order in the query often has no effect on the order in the
report.

--
Duane Hookom
Microsoft Access MVP


"Dragon" wrote:

> I have a query that is set up to display records ordered by plan date then by
> start date.
> When I use the query in a report, it doesn't appear to sort the records.
> Is there a way to make the report format the results the same as the query?
>
> Thanks,
> Dragon
From: Dragon on 13 Apr 2010 09:11
Found it! Thanks!

Dragon

"Duane Hookom" wrote:

> Reports should always be sorted using the Sorting and Grouping dialog in
> Report Design. The order in the query often has no effect on the order in the
> report.
>
> --
> Duane Hookom
> Microsoft Access MVP
>
>
> "Dragon" wrote:
>
> > I have a query that is set up to display records ordered by plan date then by
> > start date.
> > When I use the query in a report, it doesn't appear to sort the records.
> > Is there a way to make the report format the results the same as the query?
> >
> > Thanks,
> > Dragon
 | 
Pages: 1
Prev: Rotate Label on Report
Next: Using filtered form data as record source for report