T
troon
I have a form who's record source is a query. On this form I have a list
box. In this list box is displaying record sets based on a date "Between
[Start Date] and [End Date]". There is also a field called [Status] which
contains some numeric values, i.e. 1, 2, 3 ... What I would like to do is
get a count of the number of [Status]=1 or [Status]=2 etc... based on the
List Box that is being displayed on the form. However if I use something
like "=Sum(IIf([Status]=4,1,0))" it returns the count from the record source
query and not the List box which is displayed on the form. How can I
display a count (in a text box) based on values in the List box and not the
record source of the form. Thanks.
box. In this list box is displaying record sets based on a date "Between
[Start Date] and [End Date]". There is also a field called [Status] which
contains some numeric values, i.e. 1, 2, 3 ... What I would like to do is
get a count of the number of [Status]=1 or [Status]=2 etc... based on the
List Box that is being displayed on the form. However if I use something
like "=Sum(IIf([Status]=4,1,0))" it returns the count from the record source
query and not the List box which is displayed on the form. How can I
display a count (in a text box) based on values in the List box and not the
record source of the form. Thanks.