Null values

[cornishteeth]

I have two field LastMeeting and Comments. I want to count the number of fields that are not Null. I tried a variety of things but cant seem to figure it out. The result is to be put on a report. Can someone please direct me to where I can find this info. or possibly an example.

Thanks
Frank

 

[tonnic]

Hi Frank,

to count the number of columns which are not NULL the query hast to look like this:

SELECT Count([COLUMN]) AS Fields_with_data
FROM

HAVING (((Count([COLUMN)) Is Not Null));

 

[buckeye_td]

Create a Query in Design Mode and select the 2 fields, LastMeeting and Comments, and any other fields that you want to group and report on and add them to the design grid. Next select Totals by right-clicking on one of the fields in the grid and selecting Totals from the floating menu or just click the S on the Toolbar. For the LastMeeting and Comments fields, change Group By to Count. This will only count the fields if they are populated.

TD