Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 01-04-2002, 11:00 AM   #1
starfailure
Junior Member
 
Join Date: Jan 2002
Location: Mechanicsburg, PA
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
starfailure
how do i sort my data by a report field (override query sort)?

this is probably really easy to do, but for some reason, i can't get it. i have a report field (like, a calculation of two fields in a query), but i can't get the report to sort by that field.

starfailure is offline   Reply With Quote
Old 01-04-2002, 02:05 PM   #2
Rod C
Member
 
Join Date: Dec 2001
Location: Bend, OR, Deschutes
Posts: 41
Thanks: 0
Thanked 0 Times in 0 Posts
Rod C
Open your report in design view. Make sure the Formatting tool bar is on. Click the Sourting and Grouping button. You will see a popup that will help you with this.
Rod C is offline   Reply With Quote
Old 01-04-2002, 08:10 PM   #3
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 28,249
Thanks: 15
Thanked 1,591 Times in 1,511 Posts
Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all
You can't sort by a field that is calculated by the report for obvious reasons. If you want to sort by something calculated, SalesTotal for SalesPerson for example, you'll need to create a totals query that calculates the total for each SalesPerson and then join that query to the one used as the recordsource for the reports. That way the SalesTotal will be a field in the report's recordsource and then you can sort on it so the the SalesPeople are listed in order by their SalesTotals.

__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump




All times are GMT -8. The time now is 02:51 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World