Skip to Content
0
Former Member
Dec 01, 2009 at 05:27 PM

Trouble with Nulls

15 Views

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