SamBell said:I used at "=Abs(Sum([Field]))" formula in the report.
KARL DEWEY said:Post the SQL from your query.
KARL DEWEY said:Try this --
=Nz(Abs(Sum([Field])), 0)
or
=IIF(Abs(Sum([Field])) Is Null, 0, Abs(Sum([Field])))
--
KARL DEWEY
Build a little - Test a little
SamBell said:I used at "=Abs(Sum([Field]))" formula in the report.
KARL DEWEY said:Post the SQL from your query.
--
KARL DEWEY
Build a little - Test a little
:
I have a report that counts check boxes by group but not all of the "0"s are
showing up. Everything is being totaled correctly, I just need the missing
"0"s to show.
SamBell said:Still no luck. I maybe making this harder than it needs to be; I need to
count the number of times an occurrence happens in a time frame. Is there a
way to do this in a query?
KARL DEWEY said:Try this --
=Nz(Abs(Sum([Field])), 0)
or
=IIF(Abs(Sum([Field])) Is Null, 0, Abs(Sum([Field])))
--
KARL DEWEY
Build a little - Test a little
SamBell said:I used at "=Abs(Sum([Field]))" formula in the report.
:
Post the SQL from your query.
--
KARL DEWEY
Build a little - Test a little
:
I have a report that counts check boxes by group but not all of the "0"s are
showing up. Everything is being totaled correctly, I just need the missing
"0"s to show.
Duane Hookom said:Are you attempting this in a group or report header or footer section? Is it
possible there are no records to aggregate in the group? If so, you need to
use the HasData property like:
=IIf([HasData], Sum(Abs(Nz([Field],0))),0)
--
Duane Hookom
Microsoft Access MVP
SamBell said:Still no luck. I maybe making this harder than it needs to be; I need to
count the number of times an occurrence happens in a time frame. Is there a
way to do this in a query?
KARL DEWEY said:Try this --
=Nz(Abs(Sum([Field])), 0)
or
=IIF(Abs(Sum([Field])) Is Null, 0, Abs(Sum([Field])))
--
KARL DEWEY
Build a little - Test a little
:
I used at "=Abs(Sum([Field]))" formula in the report.
:
Post the SQL from your query.
--
KARL DEWEY
Build a little - Test a little
:
I have a report that counts check boxes by group but not all of the "0"s are
showing up. Everything is being totaled correctly, I just need the missing
"0"s to show.
SamBell said:I'm doing this in the group header. I assume the records are grouped since
they are totally correctly, I'm just not seeing "0"s in all the fields that
there are no occurrences in. However some of the fields are showing "0"s
Duane Hookom said:Are you attempting this in a group or report header or footer section? Is it
possible there are no records to aggregate in the group? If so, you need to
use the HasData property like:
=IIf([HasData], Sum(Abs(Nz([Field],0))),0)
--
Duane Hookom
Microsoft Access MVP
SamBell said:Still no luck. I maybe making this harder than it needs to be; I need to
count the number of times an occurrence happens in a time frame. Is there a
way to do this in a query?
:
Try this --
=Nz(Abs(Sum([Field])), 0)
or
=IIF(Abs(Sum([Field])) Is Null, 0, Abs(Sum([Field])))
--
KARL DEWEY
Build a little - Test a little
:
I used at "=Abs(Sum([Field]))" formula in the report.
:
Post the SQL from your query.
--
KARL DEWEY
Build a little - Test a little
:
I have a report that counts check boxes by group but not all of the "0"s are
showing up. Everything is being totaled correctly, I just need the missing
"0"s to show.
Duane Hookom said:Can you provide more information about your data. It wasn't until a recent
posting that you mentioned "in a time frame". What is the significance of the
time frame? If you expand or remove the time frame do the calculations work?
You suggest some 0s display and others don't. What is the difference in the
control sources and data?
Did you check the format property of the controls?
--
Duane Hookom
Microsoft Access MVP
SamBell said:I'm doing this in the group header. I assume the records are grouped since
they are totally correctly, I'm just not seeing "0"s in all the fields that
there are no occurrences in. However some of the fields are showing "0"s
Duane Hookom said:Are you attempting this in a group or report header or footer section? Is it
possible there are no records to aggregate in the group? If so, you need to
use the HasData property like:
=IIf([HasData], Sum(Abs(Nz([Field],0))),0)
--
Duane Hookom
Microsoft Access MVP
:
Still no luck. I maybe making this harder than it needs to be; I need to
count the number of times an occurrence happens in a time frame. Is there a
way to do this in a query?
:
Try this --
=Nz(Abs(Sum([Field])), 0)
or
=IIF(Abs(Sum([Field])) Is Null, 0, Abs(Sum([Field])))
--
KARL DEWEY
Build a little - Test a little
:
I used at "=Abs(Sum([Field]))" formula in the report.
:
Post the SQL from your query.
--
KARL DEWEY
Build a little - Test a little
:
I have a report that counts check boxes by group but not all of the "0"s are
showing up. Everything is being totaled correctly, I just need the missing
"0"s to show.
SamBell said:The database is to track performance problems in different departments in the
company using 4 check boxes to be checked only if it has been a problem. I
run the report once a month and need the information to only cover that
month. The way everything is currently set up I run a query to limit my
information to only cover one month at a time, then I create a report to show
the number of times each category was checked for each department. In my most
successful version of this report the totals are adding up correctly, but
there is no consistency as to where a "0" will show up; only 1 column and 1
row have all fields with a number in them. I'm still very new to Access, I
think I may have gotten in over my head and need to start at this from a new
point.
Duane Hookom said:Can you provide more information about your data. It wasn't until a recent
posting that you mentioned "in a time frame". What is the significance of the
time frame? If you expand or remove the time frame do the calculations work?
You suggest some 0s display and others don't. What is the difference in the
control sources and data?
Did you check the format property of the controls?
--
Duane Hookom
Microsoft Access MVP
SamBell said:I'm doing this in the group header. I assume the records are grouped since
they are totally correctly, I'm just not seeing "0"s in all the fields that
there are no occurrences in. However some of the fields are showing "0"s
:
Are you attempting this in a group or report header or footer section? Is it
possible there are no records to aggregate in the group? If so, you need to
use the HasData property like:
=IIf([HasData], Sum(Abs(Nz([Field],0))),0)
--
Duane Hookom
Microsoft Access MVP
:
Still no luck. I maybe making this harder than it needs to be; I need to
count the number of times an occurrence happens in a time frame. Is there a
way to do this in a query?
:
Try this --
=Nz(Abs(Sum([Field])), 0)
or
=IIF(Abs(Sum([Field])) Is Null, 0, Abs(Sum([Field])))
--
KARL DEWEY
Build a little - Test a little
:
I used at "=Abs(Sum([Field]))" formula in the report.
:
Post the SQL from your query.
--
KARL DEWEY
Build a little - Test a little
:
I have a report that counts check boxes by group but not all of the "0"s are
showing up. Everything is being totaled correctly, I just need the missing
"0"s to show.
Duane Hookom said:In the same section, add a text box with a control source of:
=Count(*)
See if the value in this text box coincides at all with issues in your other
textboxes.
--
Duane Hookom
Microsoft Access MVP
SamBell said:The database is to track performance problems in different departments in the
company using 4 check boxes to be checked only if it has been a problem. I
run the report once a month and need the information to only cover that
month. The way everything is currently set up I run a query to limit my
information to only cover one month at a time, then I create a report to show
the number of times each category was checked for each department. In my most
successful version of this report the totals are adding up correctly, but
there is no consistency as to where a "0" will show up; only 1 column and 1
row have all fields with a number in them. I'm still very new to Access, I
think I may have gotten in over my head and need to start at this from a new
point.
Duane Hookom said:Can you provide more information about your data. It wasn't until a recent
posting that you mentioned "in a time frame". What is the significance of the
time frame? If you expand or remove the time frame do the calculations work?
You suggest some 0s display and others don't. What is the difference in the
control sources and data?
Did you check the format property of the controls?
--
Duane Hookom
Microsoft Access MVP
:
I'm doing this in the group header. I assume the records are grouped since
they are totally correctly, I'm just not seeing "0"s in all the fields that
there are no occurrences in. However some of the fields are showing "0"s
:
Are you attempting this in a group or report header or footer section? Is it
possible there are no records to aggregate in the group? If so, you need to
use the HasData property like:
=IIf([HasData], Sum(Abs(Nz([Field],0))),0)
--
Duane Hookom
Microsoft Access MVP
:
Still no luck. I maybe making this harder than it needs to be; I need to
count the number of times an occurrence happens in a time frame. Is there a
way to do this in a query?
:
Try this --
=Nz(Abs(Sum([Field])), 0)
or
=IIF(Abs(Sum([Field])) Is Null, 0, Abs(Sum([Field])))
--
KARL DEWEY
Build a little - Test a little
:
I used at "=Abs(Sum([Field]))" formula in the report.
:
Post the SQL from your query.
--
KARL DEWEY
Build a little - Test a little
:
I have a report that counts check boxes by group but not all of the "0"s are
showing up. Everything is being totaled correctly, I just need the missing
"0"s to show.
SamBell said:That is giving me the total number of boxes checked for each department (row).
Duane Hookom said:In the same section, add a text box with a control source of:
=Count(*)
See if the value in this text box coincides at all with issues in your other
textboxes.
--
Duane Hookom
Microsoft Access MVP
SamBell said:The database is to track performance problems in different departments in the
company using 4 check boxes to be checked only if it has been a problem. I
run the report once a month and need the information to only cover that
month. The way everything is currently set up I run a query to limit my
information to only cover one month at a time, then I create a report to show
the number of times each category was checked for each department. In my most
successful version of this report the totals are adding up correctly, but
there is no consistency as to where a "0" will show up; only 1 column and 1
row have all fields with a number in them. I'm still very new to Access, I
think I may have gotten in over my head and need to start at this from a new
point.
:
Can you provide more information about your data. It wasn't until a recent
posting that you mentioned "in a time frame". What is the significance of the
time frame? If you expand or remove the time frame do the calculations work?
You suggest some 0s display and others don't. What is the difference in the
control sources and data?
Did you check the format property of the controls?
--
Duane Hookom
Microsoft Access MVP
:
I'm doing this in the group header. I assume the records are grouped since
they are totally correctly, I'm just not seeing "0"s in all the fields that
there are no occurrences in. However some of the fields are showing "0"s
:
Are you attempting this in a group or report header or footer section? Is it
possible there are no records to aggregate in the group? If so, you need to
use the HasData property like:
=IIf([HasData], Sum(Abs(Nz([Field],0))),0)
--
Duane Hookom
Microsoft Access MVP
:
Still no luck. I maybe making this harder than it needs to be; I need to
count the number of times an occurrence happens in a time frame. Is there a
way to do this in a query?
:
Try this --
=Nz(Abs(Sum([Field])), 0)
or
=IIF(Abs(Sum([Field])) Is Null, 0, Abs(Sum([Field])))
--
KARL DEWEY
Build a little - Test a little
:
I used at "=Abs(Sum([Field]))" formula in the report.
:
Post the SQL from your query.
--
KARL DEWEY
Build a little - Test a little
:
I have a report that counts check boxes by group but not all of the "0"s are
showing up. Everything is being totaled correctly, I just need the missing
"0"s to show.
Duane Hookom said:What are the field names and data types in your report's record source?
--
Duane Hookom
Microsoft Access MVP
SamBell said:That is giving me the total number of boxes checked for each department (row).
Duane Hookom said:In the same section, add a text box with a control source of:
=Count(*)
See if the value in this text box coincides at all with issues in your other
textboxes.
--
Duane Hookom
Microsoft Access MVP
:
The database is to track performance problems in different departments in the
company using 4 check boxes to be checked only if it has been a problem. I
run the report once a month and need the information to only cover that
month. The way everything is currently set up I run a query to limit my
information to only cover one month at a time, then I create a report to show
the number of times each category was checked for each department. In my most
successful version of this report the totals are adding up correctly, but
there is no consistency as to where a "0" will show up; only 1 column and 1
row have all fields with a number in them. I'm still very new to Access, I
think I may have gotten in over my head and need to start at this from a new
point.
:
Can you provide more information about your data. It wasn't until a recent
posting that you mentioned "in a time frame". What is the significance of the
time frame? If you expand or remove the time frame do the calculations work?
You suggest some 0s display and others don't. What is the difference in the
control sources and data?
Did you check the format property of the controls?
--
Duane Hookom
Microsoft Access MVP
:
I'm doing this in the group header. I assume the records are grouped since
they are totally correctly, I'm just not seeing "0"s in all the fields that
there are no occurrences in. However some of the fields are showing "0"s
:
Are you attempting this in a group or report header or footer section? Is it
possible there are no records to aggregate in the group? If so, you need to
use the HasData property like:
=IIf([HasData], Sum(Abs(Nz([Field],0))),0)
--
Duane Hookom
Microsoft Access MVP
:
Still no luck. I maybe making this harder than it needs to be; I need to
count the number of times an occurrence happens in a time frame. Is there a
way to do this in a query?
:
Try this --
=Nz(Abs(Sum([Field])), 0)
or
=IIF(Abs(Sum([Field])) Is Null, 0, Abs(Sum([Field])))
--
KARL DEWEY
Build a little - Test a little
:
I used at "=Abs(Sum([Field]))" formula in the report.
:
Post the SQL from your query.
--
KARL DEWEY
Build a little - Test a little
:
I have a report that counts check boxes by group but not all of the "0"s are
showing up. Everything is being totaled correctly, I just need the missing
"0"s to show.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.