|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 20th, 2006, 03:57 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
Conditional calculations
Hi Ed, Duane or anyone who can help me again
I studied access all weekend and realized just how similar it is to main frame report writing. I know how to write conditional statements, I just could not figure out where in Access. For example, I want to define a field called "loacnt" and I want to add 1 to it whenever the field "status"= LOA, I want "loacnt" = 0 when the department number changes in the grouping I've defined. Please help. -- vickilynn 
|
|
#2
February 20th, 2006, 05:51 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Conditional calculations
Again. if I understand you correctly:
create an unbound control in the group band that applies (dept#) set it's source to " =IIF(Me!status='LOA', 1) " and set the running sum property to "Over Group" Now you should get an incrementing number whenever [status]=LOA, and that numbering should reset for each dept#. -Ed "Vicki Leatherberry" wrote in message news  Hi Ed, Duane or anyone who can help me again I studied access all weekend and realized just how similar it is to main frame report writing. I know how to write conditional statements, I just could not figure out where in Access. For example, I want to define a field called "loacnt" and I want to add 1 to it whenever the field "status"= LOA, I want "loacnt" = 0 when the department number changes in the grouping I've defined. Please help. -- vickilynn
|
|
#3
February 20th, 2006, 06:11 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Conditional calculations
Thanks again Ed, it's a transition, but I'm getting it together
-- vickilynn "Ed Robichaud" wrote: Again. if I understand you correctly: create an unbound control in the group band that applies (dept#) set it's source to " =IIF(Me!status='LOA', 1) " and set the running sum property to "Over Group" Now you should get an incrementing number whenever [status]=LOA, and that numbering should reset for each dept#. -Ed "Vicki Leatherberry" wrote in message news Hi Ed, Duane or anyone who can help me again I studied access all weekend and realized just how similar it is to main frame report writing. I know how to write conditional statements, I just could not figure out where in Access. For example, I want to define a field called "loacnt" and I want to add 1 to it whenever the field "status"= LOA, I want "loacnt" = 0 when the department number changes in the grouping I've defined. Please help. -- vickilynn
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| conditional calculations (iif) | [email protected] | Setting Up & Running Reports | 15 | November 15th, 2005 05:25 AM |
| Conditional Calculations | Michael Trotter | General Discussion | 14 | October 17th, 2005 06:46 AM |
| Conditional Calculations | Syed Zeeshan Haider | Running & Setting Up Queries | 1 | August 2nd, 2005 02:24 PM |
| conditional formatting in form slows down calculations | Susan | Using Forms | 5 | June 13th, 2005 11:24 AM |
| Performing conditional calculations based on character strings | Arnie | Worksheet Functions | 0 | May 5th, 2004 06:33 PM |
Linear Mode
