Hi,

Is it possible to create a report that would show you all fields within a table that are empty?

I've created a query to only select records that have empty fields but what I'd really like is to just know the names of those fields that are empty.

For instance, for the table below:

Identifier First Name Surname Gender
x19812 Joe Bloggs
x58616 Female

I was hoping for something like the following:

Idenifier Empty Fields
x19812 Gender
x58616 First Name, Surname

When only working with a small number of fields and records, my query works fine but I need to be able to pick out missing data for over 1,000 records.

Hope you can help.

Nicola

Welcome to AWF :)

How does x19812 relate to x58616?

Hi,

They don't. Other than they are both identifiers for people.

Am I on a wild goose chase??

Thanks,

Nik

First create a query with the table you want to inspect.

Bring down the PK fields that you know are not going to be empty.

Then for each field that may be empty use the following syntax

Alias:IIF([FieldName] Is Null,"Null","")