Search results for query: *

Ro, Actually that didn't work. What now? Amy

Ro, I've tried the isnull formula and the formula doesn't work. This information is all in a subreport. Do you think it could be a formatting issue between the main and sub reports? I am stumped as to why it would clearly print every other number but "0"! I think I am correct when I say this...

Also, that isn't the field I am showing on the report. I am showing the summary of: If {NCR_37_ttx.Notices~Date} in {?This Reporting Period} then 1 else 0 and if the summary = 0, the 0 doesn't show.

Thanks. I've already tried that and it doesn't work.

Ok, the report works great, but now when you run the report, the zeros don't show up. Do I need to change my formula or is it a formatting issue? Thanks!

It works PERFECTLY!! A thousand thanks to you, lbass. I feel like a moron now because the answer was so simple!

Ok. That formula works, in a sense. It calculates this way: if that date occurs in that range, it counts all of them. So instead of getting those that occur in that range, I get all that occur (most of the time - for some reason it won't count the dates towards the beginning of the month.) The...

I need to get a sum on the number of records that occur in a parameter field. The parameter field asks the user to pick a range of dates to indicate the reporting period to be used to run the report ({?This Reporting Period}). For whatever reason, this formula works logically, but won't...