S
SRussell
I am trying to get a count of how many columns have data entered. This is
non normalized and I'm not paid to fix that So I am trying to get the
count of shirts in this case.
Alterations.Date, IIf([Shirt 1]=" ",0,1)+IIf([Shirt 2]="
",0,1)+IIf([Shirt 3]=" ",0,1)+IIf([Shirt 4]=" ",0,1) AS ShirtTotal,
IIf(IsEmpty([Shirt 1]),0,1)+IIf(isEmpty([Shirt 2]),0,1)+IIf(isEmpty([Shirt
3]),0,1)+IIf(isEmpty([Shirt 4]),0,1) AS ShirtTotal2,
column is char(50) for all of the shirts.
how do I get a count of this, I guess that I am close?
TIA
__Stephen
non normalized and I'm not paid to fix that So I am trying to get the
count of shirts in this case.
Alterations.Date, IIf([Shirt 1]=" ",0,1)+IIf([Shirt 2]="
",0,1)+IIf([Shirt 3]=" ",0,1)+IIf([Shirt 4]=" ",0,1) AS ShirtTotal,
IIf(IsEmpty([Shirt 1]),0,1)+IIf(isEmpty([Shirt 2]),0,1)+IIf(isEmpty([Shirt
3]),0,1)+IIf(isEmpty([Shirt 4]),0,1) AS ShirtTotal2,
column is char(50) for all of the shirts.
how do I get a count of this, I guess that I am close?
TIA
__Stephen