 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / November 2006AND IF formula in Access
I'm trying to do this formula in access and havin ghard time, can anyone help me please? IF[dbo.NTH_ACTIVITY_DEFINITION].ACTIVITY_DEF_DID=[dbo.NTH_ACTIVITY_DEFINITION].ACTIVITY_DEF_DID AND [dbo_NTH_RPT_CONTROLS].CONTROLS_DID=[dbo_NTH_RPT_CONTROLS].CONTROLS_DID AND [dbo_NTH_RPT_CTRL_TESTINGS].STEP_INSTANCE_ID not equal to [dbo_NTH_RPT_CTRL_TESTINGS].STEP_INSTANCE_ID) then Take to lower [dbo_NTH_RPT_CTRL_TESTINGS].STEP_INSTANCE_ID, otherwise [dbo_NTH_RPT_CTRL_TESTINGS].STEP_INSTANCE_ID) What does "Take to lower" mean? I don't recognize that as part of normal syntax for the If ... Then ... Else function. Where are you trying to do this formula? As part of code-behind-a-form? As part of a query? Regards Jeff Boyce Microsoft Office/Access MVP > I'm trying to do this formula in access and havin ghard time, can > anyone help me please? [quoted text clipped - 7 lines] > Take to lower [dbo_NTH_RPT_CTRL_TESTINGS].STEP_INSTANCE_ID, otherwise > [dbo_NTH_RPT_CTRL_TESTINGS].STEP_INSTANCE_ID) Jeff, I'm trying to build this in a query as a expression and by saying 'Take it lower' I meant to catch the first step instance only. > What does "Take to lower" mean? I don't recognize that as part of normal > syntax for the If ... Then ... Else function. [quoted text clipped - 18 lines] > > Take to lower [dbo_NTH_RPT_CTRL_TESTINGS].STEP_INSTANCE_ID, otherwise > > [dbo_NTH_RPT_CTRL_TESTINGS].STEP_INSTANCE_ID) See comments in-line below... > Jeff, > > I'm trying to build this in a query as a expression and by saying 'Take > it lower' I meant to catch the first step instance only. First, you'll need to use Access HELP to look up the proper syntax for using the function. Next, if you are trying this in a query, you need to use the IIF() function, not the If/Then/Else function. And since we aren't there, and aren't as familiar with your data as you are, "catch the first step instance" doesn't make a lot of sense. Can you provide a bit more context for us? It would probably help if you provided an example, using real data. Regards Jeff Boyce Microsoft Office/Access MVP >> What does "Take to lower" mean? I don't recognize that as part of normal >> syntax for the If ... Then ... Else function. [quoted text clipped - 19 lines] >> > Take to lower [dbo_NTH_RPT_CTRL_TESTINGS].STEP_INSTANCE_ID, otherwise >> > [dbo_NTH_RPT_CTRL_TESTINGS].STEP_INSTANCE_ID) |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.