Ahh, thanks for that tip. I'm having a similar problem regarding this field. I have a department field set up, however, that is linked to a dropdown box on another table. If a specific department is not selected anywhere on the other table it doesn't display as a zero on my query, it just doesn't show up at all. Is there a way around this? I need to show all the departments in my query, not just the ones that have been selected. Thanks.