Populate value in text field.

  • Thread starter Thread starter TyF
  • Start date Start date
T

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??
 
I placed the expression in the query, getting no results...

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

TyF said:
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??
Click to expand...
Click to expand...
 
It works... Thanks very much...

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

TyF said:
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??
Click to expand...
Click to expand...
 
Back
Top