1
  • Auto Replace Text in a table

    Is there a statement I can add that will automatically replace a text string with another string? EX> NORTH CHANGE TO BILLY BOB THROUGH OUT A FIELD

    Dapostman5 pointsBadges:
  • Access 2007 IIF statement in query criteria

    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...

    Scubacy25 pointsBadges:
  • and IIf statement in a query

    How do I write an IIF statement in a query, that does the following: if date1 - date2 is less than or = to 0 then Y else if greater than 0 then N

    Raleigh35 pointsBadges:
  • Access 2010 macros

    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...

    Danna15 pointsBadges:
  • Count IIF Statement?

    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...

    Twj21025 pointsBadges:
  • DLookup or IIF statement?

    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...

    Alexvalentina10 pointsBadges:
  • In Microsoft Access is there a way to put IIF statement criteria into a table for easier management and reference?

    I have some data with a list of Product IDs and I want to assign the Product IDs a category name based the criteria below. <br><br> IIF Product ID = #*C#* then category name = Cable<br><br> IIF Product ID = 00#* or 497* then category name = Component<br><br>...

    As2301495 pointsBadges:
  • Still having trouble with IIF in Access 2007

    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,...

    Phil12550120 pointsBadges:
  • Access IIF Statement Not Returning All Records based on Option Group

    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:...

    EngTech5510 pointsBadges:
  • Oracle SQL question

    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...

    Wanderer95775 pointsBadges:
  • IIf and showing all

    I want to show in my criteria that: IIf([Issues].[DataOrigin]=2,-1,( no criteria or (0 or -1)) If I use null instead of no criteria my result is wrong if I use (0 Or _1) in Iff function my result is same as -1 but when I use (0 Or -1) in query I have right answer. Anyway I would like to show...

    Hh13545 pointsBadges:
  • Using WildCards in IIF Statement

    Hi, I have a query that uses a field on a form to filter what information gets displayed. This is simple I know but what I need it to do is display all records if I don't enter anything in the field on the form. I tried putting the following IIF statement in the Criteria:...

    RoadDust390 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following