Solved

Like Statementm, Switch

Posted on 2013-01-21
2
178 Views
Last Modified: 2013-01-21
How can I modify this SWITCH statement to show "Below Investment Grade, Highly Speculative" for any data entered like this:
B1
B2
B3
basically a numerical modifier at the end.

I dont think I can use
[MoodyRating] like "B*"  because I a user could enter only a Baa or Ba.  

I have not copied the entire switch statement but only a bit of it:

=Switch([MoodyRating]="Baa","Investment Grade, but lower end",
[MoodyRating]="Ba1","Speculative, substantial Credit Risk",
[MoodyRating] = "B1", "Below Investment Grade, Highly Speculative")

Hope that makes sense.
0
Comment
Question by:pdvsa
2 Comments
 
LVL 29

Accepted Solution

by:
IrogSinta earned 500 total points
ID: 38802492
[MoodyRating] Like "B[0-9]", "Below Investment Grade, Highly Speculative"
0
 

Author Closing Comment

by:pdvsa
ID: 38802532
very nice.  Worked perfectly.  Thank you
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Direct Mail software 4 46
Authenticate Username & Password from MS Access to Active Directory 5 47
Run Time Error 3071 26 41
Getting Run-Time Error 13 - Type Mismatch 3 28
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now