Populate value in text field.

[TyF]

Need an account # to populate in the text field if inventory# field is empty.

IIf(Is Null([Inventory #])=[Debit Account])) or do I need to use Nz instead
of Is Null??

 

[TyF]

I placed the expression in the query, getting no results...

IIf(IsNull([Inventory #]) = True, [Debit Account], [Inventory #])
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

Need an account # to populate in the text field if inventory# field is empty.

IIf(Is Null([Inventory #])=[Debit Account])) or do I need to use Nz instead
of Is Null??

 

[TyF]

It works... Thanks very much...

IIf(IsNull([Inventory #]) = True, [Debit Account], [Inventory #])
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

Need an account # to populate in the text field if inventory# field is empty.

IIf(Is Null([Inventory #])=[Debit Account])) or do I need to use Nz instead
of Is Null??