]]>The post Auto Replace Text in a table appeared first on IT Answers.
]]>http://itknowledgeexchange.techtarget.com/itanswers/auto-replace-text-in-a-table/feed/1Access 2007 IIF statement in query criteriahttp://itknowledgeexchange.techtarget.com/itanswers/access-2007-iif-statement-in-query-criteria/
http://itknowledgeexchange.techtarget.com/itanswers/access-2007-iif-statement-in-query-criteria/#commentsThu, 12 Nov 2009 05:04:48 +0000This is a query design looking at a checkbox on a form, if its checked, I would like to return only the database fields (ConfigData) that contain text. If it isn’t checked, return all the fields whether they have text or not…Pretty basic filter I thought. It seems like I’m getting close but can’t seem...

]]>This is a query design looking at a checkbox on a form, if its checked, I would like to return only the database fields (ConfigData) that contain text. If it isn’t checked, return all the fields whether they have text or not…Pretty basic filter I thought. It seems like I’m getting close but can’t seem to get it.

]]>The post and IIf statement in a query appeared first on IT Answers.
]]>http://itknowledgeexchange.techtarget.com/itanswers/and-iif-statement-in-a-query/feed/6Access 2010 macroshttp://itknowledgeexchange.techtarget.com/itanswers/access-2010-macros/
http://itknowledgeexchange.techtarget.com/itanswers/access-2010-macros/#commentsWed, 02 Feb 2011 19:14:42 +0000I have a macro that 1)starts with a make-table query, 2)opens a report based on the new table, then 3)runs an If statement stating IF [Reports]![Reject Report]!=”NO” THEN EmailDatabaseObject called “Reject Report”. . . My problem is that after the macro completes it locks the table that was made earlier and I cannot run the...

]]>I have a macro that 1)starts with a make-table query, 2)opens a report based on the new table, then 3)runs an If statement stating IF [Reports]![Reject Report]!=”NO” THEN EmailDatabaseObject called “Reject Report”. . . My problem is that after the macro completes it locks the table that was made earlier and I cannot run the macro again unless I close the entire database and reload it. (I get a error message saying that the table is locked by another user. Please wait until the other user closes out of the program and try again; or something like that.) There is no one using the database during these tests so I have no idea why the table is staying locked. Do you have any ideas on how to modify the macro to allow it to run consistantly?

]]>http://itknowledgeexchange.techtarget.com/itanswers/access-2010-macros/feed/2Count IIF Statement?http://itknowledgeexchange.techtarget.com/itanswers/count-iif-statement/
http://itknowledgeexchange.techtarget.com/itanswers/count-iif-statement/#respondTue, 21 Dec 2010 18:49:13 +0000In the design of a query, I noticed that under the tab “Group By”, there are only a few types of commands to make calculations. For example, the commands include Sum, Avg, Min, Max, Count, StDev, Var, First, Last, Expression, Where. Is it possible to have a special command? I’d like to use countif(field>0) instead...

]]>In the design of a query, I noticed that under the tab “Group By”, there are only a few types of commands to make calculations. For example, the commands include Sum, Avg, Min, Max, Count, StDev, Var, First, Last, Expression, Where. Is it possible to have a special command? I’d like to use countif(field>0) instead of just counting the number of all the fields.

]]>http://itknowledgeexchange.techtarget.com/itanswers/count-iif-statement/feed/0DLookup or IIF statement?http://itknowledgeexchange.techtarget.com/itanswers/dlookup-or-iif-stmt/
http://itknowledgeexchange.techtarget.com/itanswers/dlookup-or-iif-stmt/#commentsMon, 11 Oct 2010 18:19:12 +0000How do I update the value of one row with the value of a different row? i want to build an expression For example: I have 3 columns. If Column 1=C and C is Null, then I want the values for C in Column 2 to = 10000 (the value from Column 2 for A)...

]]> How do I update the value of one row with the value of a different row? i want to build an expression

For example: I have 3 columns. If Column 1=C and C is Null, then I want the values for C in Column 2 to = 10000 (the value from Column 2 for A) and the values for C in Column 3 to = 22000 9the value from Column 3 for B)

]]>http://itknowledgeexchange.techtarget.com/itanswers/dlookup-or-iif-stmt/feed/1In Microsoft Access is there a way to put IIF statement criteria into a table for easier management and reference?http://itknowledgeexchange.techtarget.com/itanswers/in-microsoft-access-is-there-a-way-to-put-iif-statement-criteria-into-a-table-for-easier-management-and-reference/
http://itknowledgeexchange.techtarget.com/itanswers/in-microsoft-access-is-there-a-way-to-put-iif-statement-criteria-into-a-table-for-easier-management-and-reference/#commentsFri, 25 Jun 2010 13:52:54 +0000Question Edited by Serena3

]]>The post In Microsoft Access is there a way to put IIF statement criteria into a table for easier management and reference? appeared first on IT Answers.
]]>http://itknowledgeexchange.techtarget.com/itanswers/in-microsoft-access-is-there-a-way-to-put-iif-statement-criteria-into-a-table-for-easier-management-and-reference/feed/1Still having trouble with IIF in Access 2007http://itknowledgeexchange.techtarget.com/itanswers/still-having-trouble-with-iif-in-access-2007-2/
http://itknowledgeexchange.techtarget.com/itanswers/still-having-trouble-with-iif-in-access-2007-2/#respondMon, 15 Feb 2010 18:15:19 +0000If I type in the criteria block Is Not Null [Br _extended=”true” />then only those people who have a position assigned to them are listed and the position is listed. These are the people who get 25 points. What I need to do is to replace the position with “25″ in simple terms, if any...

]]>If I type in the criteria block Is Not Null [Br _extended="true" />then only those people who have a position assigned to them are listed and the position is listed. These are the people who get 25 points. What I need to do is to replace the position with “25″ in simple terms, if any value, then 25. Everything that anyone has sent me does not work for one reason or another

]]>http://itknowledgeexchange.techtarget.com/itanswers/still-having-trouble-with-iif-in-access-2007-2/feed/0Access IIF Statement Not Returning All Records based on Option Grouphttp://itknowledgeexchange.techtarget.com/itanswers/access-iif-statement-not-returning-all-records-based-on-option-group/
http://itknowledgeexchange.techtarget.com/itanswers/access-iif-statement-not-returning-all-records-based-on-option-group/#respondWed, 06 May 2009 20:39:13 +0000I’m using Access 2007 and have a query referencing an Option Group on a Form as a filter. The Option Group has 3 choices: Billable Manhours (value = 1), Non Billable Manhours (value = 2), All Manhours (value = 3). My query statement is: IIf([Forms]![FormName]![OptMHs]=1,True,IIf([Forms]![FormName]![OptMHs]=2,False,???)) When All Manhours is selected (value = 3), I want...

]]>I’m using Access 2007 and have a query referencing an Option Group on a Form as a filter. The Option Group has 3 choices: Billable Manhours (value = 1), Non Billable Manhours (value = 2), All Manhours (value = 3). My query statement is:

When All Manhours is selected (value = 3), I want to return all values, whether True or False. I can’t figure out what to place in my last False element to return all records. I’ve tried “”, Is Not Null, and other things, but returns an error message or no records.

]]>http://itknowledgeexchange.techtarget.com/itanswers/access-iif-statement-not-returning-all-records-based-on-option-group/feed/0Oracle SQL questionhttp://itknowledgeexchange.techtarget.com/itanswers/oracle-sql-question/
http://itknowledgeexchange.techtarget.com/itanswers/oracle-sql-question/#commentsMon, 13 Apr 2009 02:39:54 +0000I want to create a SQL script in Oracle that will run one of two possible SQL scripts based on what the user enters in the Parameter request. Since I’m unable to use IIF and If Then like I can in SQL Server, is there another way to do this? I have tried using case...

]]>I want to create a SQL script in Oracle that will run one of two possible SQL scripts based on what the user enters in the Parameter request. Since I’m unable to use IIF and If Then like I can in SQL Server, is there another way to do this? I have tried using case statements but Oracle doesn’t like it. One example I tried is: case when x then ” else select * from db end