Kamis, 10 Mei 2012

RE: [MS_AccessPros] Display rank name in report rather than value in report

 

Try having the recordsource query behind the report use expressions like

Designation: iif(fldVal<7,"low",iif(fldVal<10,"med","high"))

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 Amy
Sent: Thursday, May 10, 2012 11:23 AM
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.

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar