R
rgrantz
I have a query used as recordsource in a subreport, and it has parameters
from an open form for the DateField (so the DateField has "Where" chosen in
the Totals row). It also has the OrderedItems field at "Count," bewcause
the query is to return count of this in the given Date range. However, I
also need to have the DateField showing in the query results, becase I use
the field for grouping in the subreport/report. When I have the DateField
showing in the query design grid, I get a Null if there are no records
returned for that date range. I need to get a 0 instead, but trying to use
Nz for OrderedItems OR Date won't work (I get syntax error for
Count(Ordered.[Nz([OrderedItems],0)]
It appears I can't use Nz in a Count column in the query grid. How can I go
about doing this? The subreport right now doesn't show anything for the
control or its label if there are no records in that group's date, and even
using =Nz([CountofOrderedItems],0) as the control source of the report's
field returns the #ERROR in print preview. How can I get "0" to show in
this subreport's control when the recordsource query has no records
returned?
Thanks for any help
from an open form for the DateField (so the DateField has "Where" chosen in
the Totals row). It also has the OrderedItems field at "Count," bewcause
the query is to return count of this in the given Date range. However, I
also need to have the DateField showing in the query results, becase I use
the field for grouping in the subreport/report. When I have the DateField
showing in the query design grid, I get a Null if there are no records
returned for that date range. I need to get a 0 instead, but trying to use
Nz for OrderedItems OR Date won't work (I get syntax error for
Count(Ordered.[Nz([OrderedItems],0)]
It appears I can't use Nz in a Count column in the query grid. How can I go
about doing this? The subreport right now doesn't show anything for the
control or its label if there are no records in that group's date, and even
using =Nz([CountofOrderedItems],0) as the control source of the report's
field returns the #ERROR in print preview. How can I get "0" to show in
this subreport's control when the recordsource query has no records
returned?
Thanks for any help