By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,714 Members | 1,179 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,714 IT Pros & Developers. It's quick & easy.

Report with null values

P: n/a
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.
Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
"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!")


Nov 13 '05 #2

P: n/a
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.

Nov 13 '05 #3

P: n/a
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

Nov 13 '05 #4

P: n/a
"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])
Nov 13 '05 #5

P: n/a
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])

Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.