No sort in report

  • Thread starter Thread starter Phillip
  • Start date Start date
P

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,
 
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,

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
 
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,
 
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,
 
If I could have but one link to Access tips/functions/bugs/etc. it would be
Allen's site.
 
Back
Top