Hey Fans!
Perhaps you can help me...
I am using MS Access 2003. I have tried a number of things to get rid of the text #Error from appearing on form fields when no data present.
Tried the NZ function, also tried the IIF function, told it to give me zero if no data found, so far it seems to lead to nowhere land. What are your thoughts? Hopefully it's not very simple and I missed the boat, hee hee...
Thanks for your help!
Dököll