IF NULL - THEN N/A

[tpearo]

Is it possible to have a field automatically place N/A in it if the field is blank?

I have a report based on a query of a table of data. Some records do not have data for all fields which means in my case the data is Non Applicable (N/A).

I would like on my report instead of just leaving the space blank for it to be filled in with N/A.

Is this possible, and if so does anyone know how to do this.

Your help is appreciated in advance.

Tp

 

[Zonie32]

SELECT IIF(IsNull([yourfield]), 'N/A', [yourfield])

 

[earthandfire]

You could use Nz([FieldName],"N/A") where "N/A" is the value returned if [FieldName) is null

 

[dhookom]

If the field is numeric then I would not do anything with creating expressions with Nz() or IIf() or ...

The Format property of text boxes have functionality for displaying almost anything for Null values.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[USCIT1]

We have the same problem in a report. Where do we put the SELECT Statement???

 

[anhfuego1]

Yeah sure, try: =IIF([fld1] Is Null,N/A,[fld1])

 

[USCIT1]

Do you we put this in the report field criteria or the query field criteria???

 

[anhfuego1]

Place the IIF in the report criteria.

Let me know if it works =)

Fuego