Okay that helped a lot --- (and if any one else wants to chime in on this do feel free this is not my strongest ability) --- from what I see you would either need to include some kind IF structure --OR-- you could make more than one field (one for each dcount type) and then suppress the fields you don't want to see based off the value entered that might do the trick as well.
My problem here is that I deal mostly with Crystal Reports and I am running off of my memory since I don't have time to dig up the answer. However, I do believe that one if not both the above suggestions can be used within an Access Report. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessVBACentral/ <*> 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/
