|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 2nd, 2009, 02:55 PM
posted to microsoft.public.access
|
|||
|
|||
Populate value in text field.
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?? 
|
|
#2
July 2nd, 2009, 03:03 PM
posted to microsoft.public.access
|
|||
|
|||
|
Populate value in text field.
IIf(IsNull([Inventory #]) = True, [Debit Account], [Inventory #])
-- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "TyF" wrote: 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??
|
|
#3
July 2nd, 2009, 03:19 PM
posted to microsoft.public.access
|
|||
|
|||
|
Populate value in text field.
I placed the expression in the query, getting no results...
"Jerry Whittle" wrote: IIf(IsNull([Inventory #]) = True, [Debit Account], [Inventory #]) -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "TyF" wrote: 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??
|
|
#4
July 2nd, 2009, 03:34 PM
posted to microsoft.public.access
|
|||
|
|||
|
Populate value in text field.
It works... Thanks very much...
"Jerry Whittle" wrote: IIf(IsNull([Inventory #]) = True, [Debit Account], [Inventory #]) -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "TyF" wrote: 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??
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
