Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-access > #12850
| From | Ulrich Möller <knobbi38@arcor.de> |
|---|---|
| Newsgroups | comp.databases.ms-access |
| Subject | Re: Counting records |
| Date | 2017-11-08 23:19 +0100 |
| Organization | A noiseless patient Spider |
| Message-ID | <otvvs2$2kd$1@dont-email.me> (permalink) |
| References | <a8534302-8bae-403d-a9e0-918807b87fb5@googlegroups.com> |
Am 08.11.2017 um 20:27 schrieb internet.shopping@foobox.com: > In the header of a continuous form I frequently have a text box with Control source “= count(*)”. This works well in displaying the number of records displayed. > > Each record that is displayed has a text box containing the name of an item and a checkbox (isIncluded). The user clicks the checkboxes of those items to be included in a later phase. > > Is there an equivalent to count(*) to show the number of records where isIncluded is true? > Try "=abs(sum([isIncluded))" Ulrich
Back to comp.databases.ms-access | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
Counting records internet.shopping@foobox.com - 2017-11-08 11:27 -0800
Re: Counting records Patrick Finucane <patrickfinucanetx@gmail.com> - 2017-11-08 13:09 -0800
Re: Counting records knobbi38@gmail.com - 2017-11-08 14:24 -0800
Re: Counting records Ulrich Möller <knobbi38@arcor.de> - 2017-11-08 23:19 +0100
Re: Counting records Ulrich Möller <knobbi38@arcor.de> - 2017-11-08 22:31 +0100
Re: Counting records internet.shopping@foobox.com - 2017-11-09 04:29 -0800
csiph-web