We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Do you know how to write a SQL statement using Access 2003 with an MDB type file that uses a multiple IF statement?

zimmer9
zimmer9 asked
on
Medium Priority
321 Views
Last Modified: 2012-06-21
I am developing an Access application using Access 2003 with an MDB type file.

Do you know how to write a SELECT statement to perform the following:

If field S/L has a value of S  and  field DR/CR has a value of Credit,  then field T =  A  ELSE
If field S/L has a value of S  and  field DR/CR has a value of Debit,   then field T = B   ELSE
If field S/L has a value of L  and  field DR/CR has a value of Debit,   then field T =  C  ELSE
If field S/L has a value of L  and  field DR/CR has a value of Credit   then field T = D

Comment
Watch Question

Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.