Report Field Value from two other fields

[Bryan Easter]

Hello there wizards.

What I am wanting to do is to have either my report or a query to populate a field value based on the criteria of a check on two other fields.

Field 1 AC
Field 2 AC Need
Field 3 - if Field 2 (AC Need) is Null then this field should = Field 1 (AC), if Field 2 has a value, then Field 3 = Field 2 (AC Need)



The values in AC Need can change daily based on the movement of production.

I am using Access 2010. I'm still really new to using Access, so use small words please

Thanks.

[pbaldy]

Nz(Field2, Field1)

[Bryan Easter]

Nz(Field2, Field1)

I have no idea what that is...

I've been trying in query to do this:
Field 3: IIf([Field 2] Is Null,[Field 1]) which will return with the value Field 1, I need to expand it to include the not null.

Thanks.

[pbaldy]

Did you try it?

Field3: Nz([Field 2], [Field 1])

[Bryan Easter]

DOH! I see what I did...had an extra space in there was messing with it.

Thanks.

What does Nz do?

[pbaldy]

As detailed in help, it does exactly what you want; replaces a Null value with another.