I have this variable in a form: INTEGER Age = ((.#date - ChildBirthday)/365). It calculates the person's age based on their birthday. However, some records don't have a birthday entered yet so a big number shows up instead. Anyone have an idea how to show 0 or a blank when the column ChildBirthday is a null?
Pat Murphy 6.5++ [EMAIL PROTECTED] And big fan of RBase ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
