I need to be able to return with SQL syntax the number of fields within a record that are not null. I can do this with coding with ADO or DAO, but I am using the data environment to create a data report. Thus I need to return the value with SQL. Can someone show me the syntax for this?

Thanks

Andrew