Cool. I didn't know we had a "switch." You're awesome John.
Liz Ravenwood
Database Developer / Programmer
Super First Class Products
B/E Aerospace
O: 1.520.239.4808
www.beaerospace.com
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of John Viescas
Sent: Thursday, May 10, 2012 11:33 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Display rank name in report rather than value in report
Amy-
First, you should never never store a calculated field in a table. Surely you
can do the calculation in an expression in a query on the table? As for showing
Low, Medium, or High, you can use:
=Switch([MyFIeld] < 7, "Low", [MyField] > 9, "High", True, "Medium")
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-------------------------------------
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Amy
Sent: Thursday, May 10, 2012 8:23 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Display rank name in report rather than value in report
I have a table in which 3 columns are calculated based on other columns in same
table. I also have a report based off of this one table. The problem I am having
is not being able to display the proper data in my report.
I want the report to show a Low, Medium, or High when viewed rather than the
number value which is already in the field in table. So if a table field has a
calculated value of 4 in it, then I want the report to show a Low, whereas if
field has a calculated value of 7 then it would be rated as a Medium. The values
of 1-6 should show as Low, 7-9 as Medium and values of 10-12 I would like to be
displayed as high. Is this possible within the report itself?
I am not sure if I need to start looking at a event to make this happen, or if I
need to redo the entire report for this to happen or what. I can tell you the
table being used to create report holds data based out of other tables. Does
this change need to be made at the table level? I want the table to display the
value of the calculated field, while just having the report display the ranking.
I hope this makes some sort of sense.
Thank you in advance for any hint, assistance, and/or help anyone can offer to
me.
------------------------------------
Yahoo! Groups Links
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Tidak ada komentar:
Posting Komentar