Report with null values

[J.J.]

hi
I have created report based on a query that has Payment_Date_Field criteria
set to IsNull. So in the report i get no values for that field. My question
is next: how can I get printed on the report under Payment_Date_Filed_Label
something like "Not paid!"
tnx in advance
J.J.

[Rick Brandt]

"J.J." <no****@jj.com> wrote in message news:cc**********@ls219.htnet.hr...

hi
I have created report based on a query that has Payment_Date_Field criteria set to IsNull. So in the report i get no values for that field. My question is next: how can I get printed on the report under Payment_Date_Filed_Label something like "Not paid!"

=Nz(Payment_Date_Field , "Not paid!")

[Don Leverton]

Hi J.J,

Try Nz(Payment_Date_Field, "Not Paid!")

Don

"J.J." <no****@jj.com> wrote in message news:cc**********@ls219.htnet.hr...

hi
I have created report based on a query that has Payment_Date_Field criteria set to IsNull. So in the report i get no values for that field. My question is next: how can I get printed on the report under Payment_Date_Filed_Label something like "Not paid!"
tnx in advance
J.J.

[Jim Allensworth]

On Fri, 2 Jul 2004 00:49:33 +0200, "J.J." <no****@jj.com> wrote:

hi
I have created report based on a query that has Payment_Date_Field criteria
set to IsNull. So in the report i get no values for that field. My question
is next: how can I get printed on the report under Payment_Date_Filed_Label
something like "Not paid!"
tnx in advance
J.J.

Create a label for "Not Paid". Name it lblNotPaid.
In the On Format event of the section the label is on, put code
like...

Me.lblNotPaid.Visible = IsNull(Payment_Date_Field)

- Jim

[Pieter Linden]

"J.J." <no****@jj.com> wrote in message news:<cc**********@ls219.htnet.hr>...

hi
I have created report based on a query that has Payment_Date_Field criteria
set to IsNull. So in the report i get no values for that field. My question
is next: how can I get printed on the report under Payment_Date_Filed_Label
something like "Not paid!"
tnx in advance
J.J.

how about creating an expression in your query to do it?

IIF(IsNull([DatePaid]),"Not Paid!",[DatePaid])

[J.J.]

thanks a lot
"Pieter Linden" <pi********@hotmail.com> wrote in message
news:bf*************************@posting.google.co m...

"J.J." <no****@jj.com> wrote in message

news:<cc**********@ls219.htnet.hr>...

hi
I have created report based on a query that has Payment_Date_Field criteria set to IsNull. So in the report i get no values for that field. My question is next: how can I get printed on the report under Payment_Date_Filed_Label something like "Not paid!"
tnx in advance
J.J.

how about creating an expression in your query to do it?

IIF(IsNull([DatePaid]),"Not Paid!",[DatePaid])