No sort in report

[Phillip]

Hi,
I have a table with fields: Title, Description, etc.
I also have a report where each record in the table prints a new page with
the information from each record (Title, Description, etc). My problem is
that I want the pages of the report to be sorted by Title. I set "Order by"
to Title and "Order by on" to yes. The report still comes out of order.
What I'm I missing?????
Thanks in advance,

 

[Duane Hookom]

I don't ever trust or rely on sorting that is not done in the report's
Sorting and Grouping. I don't use sorting in the record source or the Order
By property.

 

[Phillip]

Hi Duane,
If you don't trust any of those then how do you sort a report?????
Phil

 

[Gina Whipp]

Phillip,

You didn't read the whole thing...

"...in the report's Sorting and Grouping..." is the only place Duane does
trust.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Hi Duane,
If you don't trust any of those then how do you sort a report?????
Phil

 

[Phillip]

Sorry, I missed the key word "not"......

Another question. Is there a way to select which field the report would be
sorted on from the form that calls the report? On the form that calls the
report I would like to select a field (maybe from a dropdown box) and then
have one report that would be printed sorted on the field selected. I don't
want a separate report for each sort order.
thanks,

 

[Gina Whipp]

Phillip,

Not using Sorting and Grouping... Have a look here...

http://www.databasedev.co.uk/sorting_reports.html

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Sorry, I missed the key word "not"......

Another question. Is there a way to select which field the report would be
sorted on from the form that calls the report? On the form that calls the
report I would like to select a field (maybe from a dropdown box) and then
have one report that would be printed sorted on the field selected. I don't
want a separate report for each sort order.
thanks,

 

[Duane Hookom]

Allen Browne has code that modifies the Control Source of the GroupLevels at
http://www.allenbrowne.com/ser-33.html. I find this more reliable.

 

[Gina Whipp]

Duane,

Hmmm, I should have checked there first!

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Allen Browne has code that modifies the Control Source of the GroupLevels at
http://www.allenbrowne.com/ser-33.html. I find this more reliable.

 

[Duane Hookom]

If I could have but one link to Access tips/functions/bugs/etc. it would be
Allen's site.

 

[Gina Whipp]

I agree!

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

If I could have but one link to Access tips/functions/bugs/etc. it would be
Allen's site.