Conditional calculations

V

Vicki Leatherberry

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

Ed Robichaud

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
 
V

Vicki Leatherberry

Thanks again Ed, it's a transition, but I'm getting it together
--
vickilynn


Ed Robichaud said:
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 said:
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.
Click to expand...
Click to expand...
 
Top