O
oncewaswillow
I need some help with a calculated field (hereafter called [Button] )in a
query. It needs to refer to another field(called [Type]) in the same query. I
know what I want to do, just don't know how to say it.
Iif(This is the first record,1,(Iif [Type]=value of [Type] in previous
record, value of [Button] in previous record +1,1))
hope this makes sense
query. It needs to refer to another field(called [Type]) in the same query. I
know what I want to do, just don't know how to say it.
Iif(This is the first record,1,(Iif [Type]=value of [Type] in previous
record, value of [Button] in previous record +1,1))
hope this makes sense