Null records, IFF statement?

[joe31709]

I have a query I use to run a report. In the report there is a field for mission/reimbursable work. now if the field is blank it is assumed it is mission. I want to know if there is a way to put in a statement such as a Iff statement where it is null will say Mission?

Joe

 

[neileg]

Use Nz() e.g.

Nz([YourField],"Mission")

 

[joe31709]

Use Nz() e.g.

Nz([YourField],"Mission")

Where would you put that at? in the report or query?

Joe

 

[Mile-O]

Either/Or - stick it in the query

 

[joe31709]

Either/Or - stick it in the query

In the critera field ? sorry but I am not able to think today....

 

[Mile-O]

In the critera field ? sorry but I am not able to think today....

No, as a new calculated field:

NewField: Nz([YourField],"Mission")

 

[neileg]

In a new calculated field, e.g.

NewField:Nz([YourField],"Mission")

Then include [NewField] in your report instead of [YourField]

 

[Cosmos75]

Just FYI. From the Help File

You can use the Nz function to return zero, a zero-length string (" "), or another specified value when a Variant is Null. For example, you can use this function to convert a Null value to another value and prevent it from propagating through an expression.

Syntax

Nz(variant[, valueifnull])

 

[joe31709]

In a new calculated field, e.g.

NewField:Nz([YourField],"Mission")

Then include [NewField] in your report instead of [YourField]

Thank yall.

That works great

Joe

 

[neileg]

No, as a new calculated field:

NewField: Nz([YourField],"Mission")

Flippin' echo in here...