PREV 1 NEXT
Access 2003 IIF Function?
I have a form and a subform relating to vehicles. The subform has starting mileage, ending mileage and the purpose of the vehicle's use, one of which is oil change. I would like a text box on the main form to show the next oil change mileage which should be 4500 miles from the ending mileage of the...
I have a form and a subform relating to vehicles. The subform has starting mileage, ending mileage and the purpose of the vehicle's use, one of which is oil change. I would like a text box on the main form to show the next oil change mileage which should be 4500 miles from the ending mileage of the...
25 pts.
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...
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...
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...
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...
Still having trouble with IIF in Access 2007
If I type in the criteria block [code] Is Not Null [code][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...
If I type in the criteria block [code] Is Not Null [code][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...
MS Access 2007, IIF and Null expressions
Ok what I want to do is very simple but nothing I have found is helping me. I have a field that sometime contains a values and but most of the time it is empty. What I want to do is write an expression that says if there is something in this field, then “25” I Believe that I should be using the...
Ok what I want to do is very simple but nothing I have found is helping me. I have a field that sometime contains a values and but most of the time it is empty. What I want to do is write an expression that says if there is something in this field, then “25” I Believe that I should be using the...
PREV 1 NEXT
