Count Results

[Daniel]

I have a table with a list of suggestions in it, which users can add to.
When I open the main screen, I have a subform in there linked to the table
for the suggestions and have a text box in the form.

When a user adds a new suggestion, it checks a field called
"activesuggestion", which i have as a yes/no box in the table.

In the text box in the form, I have used the =count to try and return the
number of new records added since last viewing the database

=Count([activesuggestion])

This returns all records in the table, but I would like to limit it to those
which have the activesuggestion box checked. I tried the following, but this
continues to return a "0" figure

=Count([activesuggestion])=true

Any help would be appreciated - sorry if the above doesn't make sense, but
all I want to do is show how many NEW suggestions have been created within a
form.

Thanks in advance

Daniel

 

[Ken Snell]

Try this:

=Abs(Sum([activesuggestion]))

 

[Daniel]

Thanks Ken

Just what I was looking for

Daniel

Try this:

=Abs(Sum([activesuggestion]))

--

Ken Snell
http://www.accessmvp.com/KDSnell/

I have a table with a list of suggestions in it, which users can add to.
When I open the main screen, I have a subform in there linked to the table
for the suggestions and have a text box in the form.

When a user adds a new suggestion, it checks a field called
"activesuggestion", which i have as a yes/no box in the table.

In the text box in the form, I have used the =count to try and return the
number of new records added since last viewing the database

=Count([activesuggestion])

This returns all records in the table, but I would like to limit it to
those which have the activesuggestion box checked. I tried the following,
but this continues to return a "0" figure

=Count([activesuggestion])=true

Any help would be appreciated - sorry if the above doesn't make sense,
but all I want to do is show how many NEW suggestions have been created
within a form.

Thanks in advance

Daniel