Is Null -Is Not Null

[pablavo]

I'm designing a report that has a Currency field. I want the report to show all the records that have an entered amount and below these records I want to show the records that have a null value

I thought it would be as easy as the following textbox:
=[£_Sent] Is Null
and the second textbox:
=[£_Sent] Is Not Null

the first box gives me the value (-1) and the second text box gives me (0)

I don't even know if the report layout will work because I want to show all records but with the null values on one header and the not null values in a bottom header.

Does anyone know how I might achieve this? If you can, please help

 

[neileg]

-1 is the numeric value of True and 0 is the numeric value of False.

I would do what you want by having two subreports. One based on a query that uses Is Null as a criterion in the £-Sent field and the other with Is Not Null.

 

[pablavo]

Thanks

Thanks Neileg! I'm nearly there! but I've ran into a new problem. The subreport isn't linked as the records will be different (only thing the same is the layout and fields). Which is fine.

I'm using BETWEEN AND function to create criteria for a date so that I can be specific with what records I want to see. that goes for the subreport as well. Only, if I use the function in both reports I get the parameter dialogue box repeating itself!

I wonder if there's a way to have it come up once and perhaps reference the subreports date to the reports function?

Anyone?

 

[boblarson]

I wonder if there's a way to have it come up once and perhaps reference the subreports date to the reports function?

See my response to this question in your other post about it:

http://www.access-programmers.co.uk/forums/showpost.php?p=622829&postcount=2