Quote Originally Posted by FriQenstein View Post
Yep. I though about just leaving it NULL for units with no S/N, but upper management is picky about that kind of stuff. I think I'll just tell them that this is the way it is and they'll have to deal.
It's just easier in the long run, plus, there is less clutter on the Reports that are generated as well. A bunch of N/As just add to the clutter causing the eyes to glaze over.

Thanks.

Also, you can leave it NULL in the tables and use the format @;"N/A" for the fields in forms and reports, to have your cake and eat it too. ;-)