By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,635 Members | 917 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,635 IT Pros & Developers. It's quick & easy.

Calculations on a report

P: n/a
Hi, new to access asking what is probably easy question, using access
2003. I have 1 table, one query and 1 report. On the report it shows
weekly monthly and yearly p&l figures from various years. I would like
to be able to find our best and worst week, month year and show the
difference on a report.
EG: 2003 week 23 net 20000 profit 1000
2004 week 23 net 15000 profit 3000
total net <-5000> profit 2000
Any help is appreciated
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Easiest way is to just sort (on the report) the Profit column in
descending order. Open the Grouping/Sorting dialog box & put the Profit
column at the top of the list of columns. Set its sort type to
Descending. The "best" performing will be at the top of the report the
"worst" performing will be at the bottom of the report.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

Jerry wrote:
Hi, new to access asking what is probably easy question, using access
2003. I have 1 table, one query and 1 report. On the report it shows
weekly monthly and yearly p&l figures from various years. I would like
to be able to find our best and worst week, month year and show the
difference on a report.
EG: 2003 week 23 net 20000 profit 1000
2004 week 23 net 15000 profit 3000
total net <-5000> profit 2000
Any help is appreciated


Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.