I would like to display the number of "not null" values that exist in two separate fields. Fields "Parent_1" and "Parent_2" hold parents names, and I simply need to know the total number of parents. Will the Count function do this? If so, can anyone help me on the proper syntax?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
count not null values in two fields
- Thread starter sdavid74
- Start date
Count will work . . it also will not count rows which are null, which is what you want.
You don't say where your are displaying this, but in a report for example, put this in a group header or footer as the source of an unbound text box:
=Count(YourField)
Do this for both fields and you should be fine. - - - -
Bryan
You don't say where your are displaying this, but in a report for example, put this in a group header or footer as the source of an unbound text box:
=Count(YourField)
Do this for both fields and you should be fine. - - - -
Bryan
Count will work . . it also will not count rows which are null, so long as you specify a field name, which is what you want.
You don't say where your are displaying this, but in a report for example, put this in a group header or footer as the source of an unbound text box:
=Count(YourField)
Do this for both fields and you should be fine. - - - -
Bryan
You don't say where your are displaying this, but in a report for example, put this in a group header or footer as the source of an unbound text box:
=Count(YourField)
Do this for both fields and you should be fine. - - - -
Bryan
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question