Data Sheet and Calculation

[123]

Thank you
If I have subform datasheet consist of detail and form footer
I want to put expression in form form footer section count number of
something where is condition..
For example:
record source for textbox =count [ID] where ID=5
is this possible

 

[TC]

This might or might not work for you. Try it & see.

=sum (iif ([ID]=5, 1, 0))

HTH,
TC

 

[Marshall Barton]

Thank you
If I have subform datasheet consist of detail and form footer
I want to put expression in form form footer section count number of
something where is condition..
For example:
record source for textbox =count [ID] where ID=5
is this possible

Possible, but it should be more like this:

=Abs(Sum([ID] = 5))

or without the tricks:

=Sum(IIf(ID = 5, 1, 0))

Or, If you prefer:

=Count(IIf(ID = 5, 1, Null))

 

[123]

TC
Marshall Barton
Thank you for your help and answer I have test all and this expression is
work
=Abs(Sum([ID] = 5))
thank you

Thank you
If I have subform datasheet consist of detail and form footer
I want to put expression in form form footer section count number of
something where is condition..
For example:
record source for textbox =count [ID] where ID=5
is this possible

Possible, but it should be more like this:

=Abs(Sum([ID] = 5))

or without the tricks:

=Sum(IIf(ID = 5, 1, 0))

Or, If you prefer:

=Count(IIf(ID = 5, 1, Null))