Re : [ExcelVBA] Help me here Please !!

 

Hello , Better to send us the sql query code associated with your problem And the description of fields composed in your access table Because somethins don t match => in this case test to add a new fied Containing the same data to join y and y instead of your difficult mapping in code IIF You can afford thid kind of deormalized schema structure of tables Because room seems not to be the problem at all Hand => Have a nice day more comprehensive like this other ii => isn t it @++SC Ery Envoyé depuis Yahoo Mail pour Android

---

From: Satheesh Kumar <satheesh_it47@yahoo.com>;
To: <ExcelVBA@yahoogroups.com>;
Subject: [ExcelVBA] Help me here Please !!
Sent: Wed, Apr 2, 2014 10:50:35 AM

Hi Everyone,   In My project, we connecting to MS Access from MS Excel, in excel we have one dropdown (medd) with Yes or No values. At the same time, in MS Access, we have column Med_D with Y or N values. So, if the user selects 'Yes' from the dropdown, then it should fetch the MS Access rows where Med_D = Y. If the user selects 'No' from the dropdown, then it should fetch the MS Access rows where Med_D in ('Y','N'). I want to check this condition in a single query, we cant use CASE in Access, tried IIF & Switch but I got failed.   Thanks Satheesh Kumar S

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (4)

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Visit Your Group

• New Members 4

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___