I am one of the people who do not like access.

I have had too many experiences with poorly built access (and FileMaker Pro) 'applications' that I never want to have...

This is definitely a MySQL syntax issue.

You would be better served by posting this on a MySQL specific site, but I'll give it a stab as I have a soft...

Great question and explanation!

I am more of a developer than a DBA and the more time I spend on this site, the more I realize how little I know.

I have run into this before and it was because the field in my report could not handle the NULL value.

Use either IsNULL or Coalesce in SQL or IsNothing in...