Order by not working

[RipperT]

Hello,
I have a report that contains a DOB field that is properly formatted as a
Date field in the table. The query upon which the report is based is ordered
by the field DOB ASC and when the query is run, the rec's are ordered
properly by date. The report, however shows some dates starting in 00, 01,
02, 03, then 97, 97, 99. The reports order by property is set to DOB ASC and
order by on is set to 'yes'. I don't know what else to do. Pulling my hair
out isn't working either. Please help.

Rip

 

[Duane Hookom]

Did you set the sorting in the Sorting and Grouping dialog? Is the
expression in this dialog an actual date field?

 

[RipperT]

I've set the sorting and grouping in the dialog box. Thanx for the help. Out
of all that I mentioned (the order-by in the query, the report's order-by
property, and the sorting and grouping), are any not necessary? Do any take
precendence over the other?

Many thanx,

Ripper

 

[PC Datasheet]

A report nullifies any sorting you have in the recordsource query. You must
set sorting in a report in Grouping and Sorting. You will actually gain in
performance by removing sorting in your query.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

 

[RipperT]

Thanx, PC.

Of course, this begs the question: What's the best way to let the user
select how the report should be sorted? Macro help says I can enter the name
of a 'filter saved as a query' in the "filter name" box of an OpenReport
macro. This seems to conflict with your advice that I must use Sorting and
Grouping to sort the report. Any advice on this would be appreciated.

Many thanx,

Ripper

 

[Duane Hookom]

There is sample code for sorting a report at runtime on Allen Browne's page
http://allenbrowne.com/ser-33.html.