Count Results

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

Try this:

=Abs(Sum([activesuggestion]))

--

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



"Daniel" wrote in message
...
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

Thanks Ken

Just what I was looking for

Daniel


"Ken Snell" wrote in message
...
Try this:

=Abs(Sum([activesuggestion]))

--

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



"Daniel" wrote in message
...
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