J
John
I have a continuous main form. In the form header I have an unbound
combobox ([cboLot_Num],1 col only) wth approx 6 selections from a totals
query row source.
I would like to select an item like "LotNo 3" from the combobox, and in the
main form footer, show the count of alll records that meet that criteria in
[Location]. Can't seem to get the syntax right. Footer field name is
[Lot_Count]
=sum(iif([Location] = "LotNo 3",1,0)) --works
=sum(iif([Location] = [cboLot_Num],1,0)) --fails with #error
There are 20 "LotNo 3" [Location] records.
Tried all kinds of different syntax for refering to [cboLot_Num], but can't
seem to get the calculation to recognize the contents.
Thanks for any help,
John
combobox ([cboLot_Num],1 col only) wth approx 6 selections from a totals
query row source.
I would like to select an item like "LotNo 3" from the combobox, and in the
main form footer, show the count of alll records that meet that criteria in
[Location]. Can't seem to get the syntax right. Footer field name is
[Lot_Count]
=sum(iif([Location] = "LotNo 3",1,0)) --works
=sum(iif([Location] = [cboLot_Num],1,0)) --fails with #error
There are 20 "LotNo 3" [Location] records.
Tried all kinds of different syntax for refering to [cboLot_Num], but can't
seem to get the calculation to recognize the contents.
Thanks for any help,
John