S
Squiggles
Hi,
I'm somewhat new to MS Access but not to programming. I'm hoping
someone can point me in the right direction.
Here's my quest. I'd like to create a field (FldC) based on the
following logic:
If FldA = "-" Then
FldC = FldB
Else
FldC = FldA
End If
And to complicate matters, I'd like to bump* a Group total by 1 every
time FldC is "Empty" (Null or "").
I'm currently considering this logic at the "Report" level but it
might be handy at the "Query" level also, selecting or excluding
records based on the derived value of "FldC".
A direct answer would be neat but a pointer to some MS Access tome**
would be just as helpful to me.
Thanks in advance
*Or set another new field to 0 or 1 if we're working at the Query
level
**chapter and verse please
I'm somewhat new to MS Access but not to programming. I'm hoping
someone can point me in the right direction.
Here's my quest. I'd like to create a field (FldC) based on the
following logic:
If FldA = "-" Then
FldC = FldB
Else
FldC = FldA
End If
And to complicate matters, I'd like to bump* a Group total by 1 every
time FldC is "Empty" (Null or "").
I'm currently considering this logic at the "Report" level but it
might be handy at the "Query" level also, selecting or excluding
records based on the derived value of "FldC".
A direct answer would be neat but a pointer to some MS Access tome**
would be just as helpful to me.
Thanks in advance
*Or set another new field to 0 or 1 if we're working at the Query
level
**chapter and verse please