G
Guest
How can I code a detail line to print No Value when the query returns
no value?
TIA
no value?
TIA
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Duane Hookom
Isn't that what happens? Or, do you want to print the text "No Value"? If
so, try:
=Nz([YourField],"No Value")
so, try:
=Nz([YourField],"No Value")
G
Guest
Where do I put this line of code?
Thanks.
--
Steve COA-NM
Thanks.
--
Steve COA-NM
Duane Hookom said:Isn't that what happens? Or, do you want to print the text "No Value"? If
so, try:
=Nz([YourField],"No Value")
--
Duane Hookom
MS Access MVP
Steve COA-NM said:How can I code a detail line to print No Value when the query returns
no value?
TIA
G
Guest
Duane I did what you posted and it worked! - Thank you very much.
--
Steve COA-NM
--
Steve COA-NM
Duane Hookom said:Isn't that what happens? Or, do you want to print the text "No Value"? If
so, try:
=Nz([YourField],"No Value")
--
Duane Hookom
MS Access MVP
Steve COA-NM said:How can I code a detail line to print No Value when the query returns
no value?
TIA