Hi Jim, Do you have all the fields on your subform as numeric fields and have set the default to 0?
Glenn P. Jones IHS -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of jmw95823 Sent: Tuesday, 12 July, 2005 5:13 PM To: [email protected] Subject: [AccessDevelopers] This is easy, but I forgot how to do it: Show main form calculation as $0 I have a field on my main form which shows the sum of $$ from records on subform by common ID. If there are no records on subform, I want to show $0 in my main form text field instead of #Error or blank. Any help in reviving my memory will be appreciated. Thanks. Jim Please zip all files prior to uploading to Files section. Yahoo! Groups Links Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
