I have a program that I wrote a report to get called from, and I am having trouble with the Invoice.Project_ID being null. So I was trying to use this:
{Project.Project_Status} = {?Project_Status} and
{Project.Programmer} = {?Programmer} and
({Project.Project_ID} = {Invoice.Project_ID}) or
(isnull ({Project.Project_ID} = {Invoice.Project_ID}))
OR
{Project.Project_Status} = {?Project_Status} and
{Project.Programmer} = {?Programmer} and
({Project.Project_ID} = {Invoice.Project_ID}) or
(({Project.Project_ID} = {Invoice.Project_ID})isnull)
I'm fairly new so I'm not used to the syntax for nulls. I have checked the boxes that turn nulls into default values but that doesn't seem to make any difference.
Thanks in advance for you help