selecting report criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I setup a report to print all records that have data in a field named
"follow-up". This field contains dates, but I don't want a select date. I
want any and all records that have information in this field. For client's
which this field is blank, nothing should print.

Thanks,
 
Collette,

DoCmd.OpenReport "YourReportName",,,Nz([Follow-up]," ")>" "

The Nz() function will detect nulls or anything else without getting tangled
in the Is Null construct which can give you what you might think are
arbitrary results.

Which reminds me. Using this construct, if the follow-up field contains only
blank spaces, nothing will print. I assume, though, that's what you want.

Hope this helps,

Sam
 
Oops, I forgot to tell you. Follow-up must be a field in the report and its
record source as well. If it isn't, you must add it to the record source and
make a bound textbox in the report as well, although you can set the Visible
property of this textbox to No.

Sam
Collette,

DoCmd.OpenReport "YourReportName",,,Nz([Follow-up]," ")>" "

The Nz() function will detect nulls or anything else without getting tangled
in the Is Null construct which can give you what you might think are
arbitrary results.

Which reminds me. Using this construct, if the follow-up field contains only
blank spaces, nothing will print. I assume, though, that's what you want.

Hope this helps,

Sam
How can I setup a report to print all records that have data in a field named
"follow-up". This field contains dates, but I don't want a select date. I
want any and all records that have information in this field. For client's
which this field is blank, nothing should print.

Thanks,
Click to expand...
Click to expand...
 
Yes followup is a field in the report and I do want and have it showing. And
you are correct in assuming I don't want information to appear if there is no
date in the followup field. However, if you'll forgive my ignorance, where
am I to enter the command you suggest using? Thanks again,
--
Collette


OfficeDev18 via AccessMonster.com said:
Oops, I forgot to tell you. Follow-up must be a field in the report and its
record source as well. If it isn't, you must add it to the record source and
make a bound textbox in the report as well, although you can set the Visible
property of this textbox to No.

Sam
Collette,

DoCmd.OpenReport "YourReportName",,,Nz([Follow-up]," ")>" "

The Nz() function will detect nulls or anything else without getting tangled
in the Is Null construct which can give you what you might think are
arbitrary results.

Which reminds me. Using this construct, if the follow-up field contains only
blank spaces, nothing will print. I assume, though, that's what you want.

Hope this helps,

Sam
How can I setup a report to print all records that have data in a field named
"follow-up". This field contains dates, but I don't want a select date. I
want any and all records that have information in this field. For client's
which this field is blank, nothing should print.

Thanks,
Click to expand...
Click to expand...
Click to expand...
 
Oh, I assumed you were working in a form. If you are simply double-clicking
on a report to print/display it, you can do the follwing:

Open the report in design mode. In the line for Filter, simply put the Nz()
function in parens, as in

(Nz([Follow-up]," ")>" ")

Sorry for the assumption, and I hope this helps,

Sam
Yes followup is a field in the report and I do want and have it showing. And
you are correct in assuming I don't want information to appear if there is no
date in the followup field. However, if you'll forgive my ignorance, where
am I to enter the command you suggest using? Thanks again,
Oops, I forgot to tell you. Follow-up must be a field in the report and its
record source as well. If it isn't, you must add it to the record source and
Click to expand...
[quoted text clipped - 24 lines]
Click to expand...
 
And... Set Filter On to Yes.

Sam
Oh, I assumed you were working in a form. If you are simply double-clicking
on a report to print/display it, you can do the follwing:

Open the report in design mode. In the line for Filter, simply put the Nz()
function in parens, as in

(Nz([Follow-up]," ")>" ")

Sorry for the assumption, and I hope this helps,

Sam
Yes followup is a field in the report and I do want and have it showing. And
you are correct in assuming I don't want information to appear if there is no
Click to expand...
[quoted text clipped - 5 lines]
Click to expand...
 
Back
Top